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!