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

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

regards
FSt1

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

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

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

=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