Help with OR statement

M

MrMike

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!
 
B

Bob Phillips

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

perhaps?


--

HTH

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

Duke Carey

try
=1*(O4=1)+2*And(O4=7,O3<7)

or Bob's, with a slight change

=IF(O4=1,1,IF(AND(O4=7,O3<7),2,0))
 
Top