Discussion Locked

MS Excel Formula - Revised "IF Expression"

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I understand that I need to utilize the IF in my expressions on MS Excel but I am receiving errors. So here is what I need help writing.
I need for cell B33 to perform the following operations based on what E21 reflects.

So if the value of E21 is 97% or less, then it needs to multiply B23 by 1.04;
if the value of E21 is 95% or less, then it needs to multiply B23 by .78;
if the value of E21 is 90% or less, then it needs to multiply E21 by .52;
if the value of E21 is 85% or less, then it needs to multiply E21 by .32;
if the value of E21 is 80% or less, then it needs to show 0.

How can I write this into cell B33 with no errors?

3 replies

by dklippert

Start with the samllest value. When the IF statement is true, it stops the comparison.

=IF(E21<=0.8,0,IF(E21<=0.85,E21*0.32,IF(E21<=0.9,E21*0.52,IF(E21<=0.95,B23*0.78,IF(E21<=0.97,B23*1.04,E21)))))

This discussion is closed to new replies.