Bad day for formulas

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

Excel 2007
I know it's a simple formula, but I just can't make it work;
If cell F5 equals 2, 3, or 4, then cell A8 must equal 1
 
In cell A8:

=(IF(OR(F5=2, F5=3, F5=4), 1, "Not 1"))

You need to decide what goes in the cell if it is not a "1".
 
Canon said:
I know it's a simple formula, but I just can't make it work;
If cell F5 equals 2, 3, or 4, then cell A8 must equal 1
Click to expand...

=IF(OR(F5={2,3,4}),1,0)

Sustitute whatever you want in place of 0 (zero) when none of those
conditions is true.

And if zero is what you want, the following will do:

=OR(F5={2,3,4})*1

or

=--OR(F5={2,3,4})
 
Back
Top