General discussion
February 25, 2004 at 11:18 AM
jgreer

MS Excel Formula – Revised “IF Expression”

by jgreer . Updated 22 years, 7 months ago

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?

This discussion is locked

All Comments