If Formula

[QPM]

Hi there,

I have attached an Excel file on how to use IF formula. I cannot figure out how to show the correct figures.

I have also other discussion regarding this, please see the link:

http://www.mrexcel.com/forum/showthr...=1#post2277414

Any idea guys?

Regards.

[DonkeyOte]

Not very clear... perhaps:

=IF((A1-B1)<0,0,IF((C1-B1)<(A1-B1),1,(A1-B1)/(C1-B1)))

or another way

=IF(A1<B1,0,MIN(1,(A1-B1)/(C1-B1)))

[QPM]

Thank you so much... I really appreciate it.