Multiple IF function (maybe OR)

  • Thread starter Thread starter mpenkala
  • Start date Start date
M

mpenkala

Hi all,

I need some help with a chart I'm making.

I want an if function to do the following:

IF B1=1,2,3 or 9, then mark B2 with an "x".

Should be simple, but I can never figure out the multiple numbers.

Thanks,
Matt
 
Hey Bernard,

how can I modify this formula so that it doesn't give me an "x" when the
cell is blank and my formula is
=IF(OR(B1={0,1,2,7}),"X","")

Thanks!
Matt
 
=IF(B1="","",IF(OR(B1={0,1,2,7}),"X",""))
or
=IF(AND(B1<>"",OR(B1={0,1,2,7})),"X","")
 
Back
Top