Conflicting Function Issues: (lesser or equal function)

[hdjc]

Dear all,

Can I seek some assistance on this:

Why does it shows 5% instead of 10%? Shouldn't X198 shows 10% instead?

X198=55%

=IF(X198<=75%,5%,
IF(X198<=55%,10%,
IF(X198<=45%,25%,
IF(X198<=25%,25%,
IF(X198<=35%,25%,
IF(X198<=15%,25%))))))

[Phuocam]

Try:

=IF(X198<=45%,25%,
IF(X198<=55%,10%,
IF(X198<=75%,5%)))

[hdjc]

Dear Phuocam,

It works!!! This helps alot. Thank You very much. You are awesome as usual!