Trying to create a range in an IF function
 

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?


--
dmorgenstern
------------------------------------------------------------------------
dmorgenstern's Profile: http://www.excelforum.com/member.php...o&userid=32194
View this thread: http://www.excelforum.com/showthread...hreadid=519411

Trying to create a range in an IF function
 

check out JE McGimpsey's website

Using SUMPRODUCT to calculate commissions or taxes using marginal rates

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



"dmorgenstern" wrote:


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?


--
dmorgenstern
------------------------------------------------------------------------
dmorgenstern's Profile: http://www.excelforum.com/member.php...o&userid=32194
View this thread: http://www.excelforum.com/showthread...hreadid=519411

Trying to create a range in an IF function
 

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

Vaya con Dios,
Chuck, CABGx3



"dmorgenstern" wrote:


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?


--
dmorgenstern
------------------------------------------------------------------------
dmorgenstern's Profile: http://www.excelforum.com/member.php...o&userid=32194
View this thread: http://www.excelforum.com/showthread...hreadid=519411