Using If/or

[Rich]

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

 

[FSt1]

hi
try this...
=IF(OR(A1="Frame",A1="Turnkey",A1="Shell"),"X","")

regards
FSt1

 

[Dave Peterson]

Another way:

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

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

 

[Jill]

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]

=if(a1="Frame","X",if(a1="turnkey","y",if(a1="shell","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.)