Previous Topic Next Topic

Advanced IF THEN formula

Closed
gfraga99 - Jan 20, 2010 at 10:26 AM
 WutUP - Jan 21, 2010 at 09:54 PM
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

Answer 1 / 1
WutUP
Jan 21, 2010 at 09:54 PM
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,"")))
0