Advanced IF THEN formula

gfraga99 - Jan 20, 2010 at 10:26 AM
 WutUP - Jan 21, 2010 at 09:54 PM

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.