# Look at the greater value and use in formula

Solved/Closed
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
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