I think that if the list of options is more than a just a few, a =vlookup()
function would work nicely.

It may seem a little complex to start, but once you use it, you'll find tons of
more reasons to use it.

Debra Dalgleish has some nice instructions at:
http://contextures.com/xlFunctions02.html

BadSector wrote:

I am setting up a basic excel spreadsheet and really have got no experience
with excel. I want to do something real basic like if A2=laptop display $10
or if A2=desktop display $20 how do I do this?

--

Dave Peterson