Excel formula

[Closed]
Report
Posts
1
Registration date
Thursday December 26, 2013
Status
Member
Last seen
December 26, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria


If 033>1 or P33>1 then I need it to complete the equation G33/J33*12*(O33+P33)

if THE ABOVE IS NOT TRUE,

THEN I NEED IT TO FIGURE IS N<1, IF TRUE RETURN ZERO, IF FALSE G33/J33

Please help!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
try this formula

=IF(OR(O33>1,P33>1),"",(G33/J33)*12*(O33+P33))

second itesm (N<1) is not clear. N is not a cell address.it should be N2 or N33 etcs.