Advanced IF THEN formula

Closed
Report
-
 WutUP -
Hello,

Here is my situation. I have a figure that will be multiplied by a percent depending on the amount.

If the amount is less than 116 then multiply by .03
If amount is between 116 and 130 multiply by .04
If amount is 131 or greater multiply by .05

This is Excel 2007

Thanks for any help.

1 reply

See if this is what you need. I used a cell reference. I am guessing that is what you are asking.


=IF(A1<116,A1*0.03,IF(A1<=130,A1*0.04,IF(A1>=131,A1*0.05,"")))