Previous Topic Next Topic

Excel formula

Closed
apg913 Posts 1 Registration date Thursday December 26, 2013 Status Member Last seen December 26, 2013 - Dec 26, 2013 at 05:50 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 27, 2013 at 12:01 AM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 27, 2013 at 12:01 AM
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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response