Report

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

Ask a question Gouws 46Posts Sunday February 7, 2010Registration date April 15, 2012 Last seen - Last answered on Nov 5, 2010 at 02:32 AM by Gouws
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.

Helpful
+1
plus moins
=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
Was this answer helpful?  
Helpful
+0
plus moins
TX, revised formula as suggested and it's working very good

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!