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" wrote:

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

Have a look in the help index for AND.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Canon" wrote in message
...
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

"Canon" wrote:
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})