Look at the greater value and use in formula [Solved/Closed]

Gouws 46 Posts Sunday February 7, 2010Registration date April 15, 2012 Last seen - Oct 1, 2010 at 02:44 AM - Latest reply: Gouws 46 Posts Sunday February 7, 2010Registration date April 15, 2012 Last seen
- Nov 5, 2010 at 02:32 AM
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.

See more 

2 replies

Best answer
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Oct 1, 2010 at 05:20 AM
1
Thank you
=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

Thank you, venkat1926 1

Something to say? Add comment

CCM has helped 1679 users this month

Gouws 46 Posts Sunday February 7, 2010Registration date April 15, 2012 Last seen - Nov 5, 2010 at 02:32 AM
0
Thank you
TX, revised formula as suggested and it's working very good