Bad day for formulas

[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

 

[Karin]

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

 

[Don Guillett]

Have a look in the help index for AND.

 

[JoeU2004]

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

=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})