Look at the greater value and use in formula

Solved/Closed
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
-
Hello,

Can someone assist me with a formula that will look at the greater number and then use it in a formula.

Currenly my formula is =IF(OR(G27=0),0,(G27-(G30+G31+G32+G35+G36)))

I want the formula to look at which one is the greatest between G31 and G32 and then use the > one in the place of G31+G32 in the formula.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
=IF(OR(G27=0),0,(G27-(G30+max(G31,G32)+G35+G36)))


mistake in the formula

or(g27=0) this ok what i the other one in "or"

"or" should have two components
something like tis
or(g27=0,g27=3)

study and revise the formulas. regarding max use the part given by me
1
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012

TX, revised formula as suggested and it's working very good
0