Using If/or

R

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.
 
D

Dave Peterson

Another way:

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

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

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?
 
D

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.)
 
Top