Trying to create a range in an IF function

[dmorgenstern]

I am trying to build a commission worksheet for myself. Am having
trouble with a multiple IF statement function. In particular, I am
trying to figure out how you bury a range into the IF statement. Here
is my function:

=IF(E5<175000,C5*0.055,IF(E5>=175000,C5*0.075))

What I really want to do is calculate a result based on a number range,
i.e. IF number is between 170000 AND 218000, C5*.075

Can anyone help with that?

 

[Guest]

check out JE McGimpsey's website

Using SUMPRODUCT to calculate commissions or taxes using marginal rates

http://www.mcgimpsey.com/excel/variablerate.html

 

[Guest]

=IF(AND(C5>=170000,C5<=218000),C5*0.075,IF(C5<170000,C5*0.055,"Over Range"))

Vaya con Dios,
Chuck, CABGx3