Advanced IF THEN formula Closed

Question

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.

WutUP · Answer

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,"")))

Advanced IF THEN formula

1 response

Similar discussions

Subscribe To Our Newsletter!