| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function problem regarding cell range | Excel Worksheet Functions | |||
| how to create a conditional formula for a range of cells? | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Linear Mode
