Formula
here is one way
=if(a1<500,a1*.4,if(a1<750,a1*.35,if(a1<1000,a1*.3 ,a1*.2)))
"Rover" wrote:
I need some help, as I have not able to come up with a formula. Any
assistance would be greatly appreciated...
So lets say you have a value in cell A1...I need a formula in cell B1
calculating based on the value of cell A1 with the folowing conditions...If
the value of A1 is less than 500, I need to multiply it by 40%; if the value
of A1 is between 500 and 750, I need to multiply it by 35%; if the value is
between 750 and 1000 need to multiply it by 30% and if its greater than 1000,
then multiply it by 20%...
Thanks for the Help...Fred
|