You could simplify that further:

=OR(A2=1,A2=2,A2=5,A2=25)

or just:

=OR(A2={1,2,5,25})

Hope this helps.

Pete

On Apr 23, 1:24*pm, "MartinW" wrote:
Hi Sean,

You can do it like this,
=IF(OR(A2=1,A2=2,A2=5,A2=25),TRUE,FALSE)

or you can be simplify it like this,
=IF(OR(A2={1,2,5,25}),TRUE,FALSE)

HTH
Martin

"Sean.rogers" wrote in message

...



Can you have multiple tests, in the test section of the if statement? For
example.
If (A2=1or2or5or25,True,False)- Hide quoted text -

- Show quoted text -