• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What does this formula mean ?

rescobar

New Member
I'm far away from being an excel guru and I'm having trouble translating this excel formula to a php web based application.


The one I've stomped into is this formula:


=MAX(0,IF((1-(450000-B9)/100000)>1,1,((1-(450000-B9)/100000))))


Could you guys break it down and explain what it does?


Regards.
 
Take the Maximum of

0,

IF((1-(450000-B9)/100000)>1, 1

or

(1-(450000-B9)/100000)
 
It is determining 450,000 minus B9 divided by 100,000 but with a maximum of 1, and zeroising if negative.


It can better be written as


=MAX(0,MIN(1,1-(450000-B9)/100000))
 
Back
Top