=if(O4=1,1,IF(And(O4=7,O3<7))),2,0))

perhaps?


--

HTH

RP
(remove nothere from the email address if mailing direct)


"MrMike" wrote in message
...
Hi. Currently I have the following Excel formula, which returns 2 if the
statement is TRUE and returns 0 if the statement is FALSE.

=if(Or(O4=1,(And(O4=7,O3<7))),2,0)

Is it possible to format this statement to return a 1 if the OR statement
is
TRUE, but return a 2 if the AND statement is TRUE? Thanks!