Trying to create a range in an IF function

D

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?
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top