=if(a1="Frame","X",if(a1="turnkey","y",if(a1="shel l","Z","not specified!")))

or if a1 could only be one of those 3:
=if(a1="Frame","X",if(a1="turnkey","y","z"))

(anything else besides Frame or turnkey will show a Z.)

Jill wrote:

Hi, what if I want to do this for multiple options, i.e:

if A1=frame then X; A1=turnkey then Y; A1=shell then Z?

"Dave Peterson" wrote:

Another way:

=IF(OR(A1={"Frame","turnkey","shell"}),"X","")

It's a little shorter (and easier to update) if the list changes.

Rich wrote:

I don't know how to structure the formula to: IF A1="Frame" OR "Turnkey"OR
"Shell", then insert an "X", else leave blank.

--

Dave Peterson


--

Dave Peterson