| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF statements
I am trying to calculate a graduated bonus using IF statements. My problem
is that it only recognizes the criteria for the last IF statement. =IF((B25-D25)<12000,0,IF((B25-D25)12000<15000,((D25-J25)-12000)*0.25,IF((B25-D25)15000<17000,((B25-D25)-15000)*0.3+(3000*0.25),IF((B25-D25)17000,((B25-D25)-17000)*0.35+(3000*0.25)+2000*0.3)))) If production - sales < $12000 then $0 bonus If production - sales $12000< $15000 then 25% over $12000 If production - sales $15000 < $17000 then 30% over $15000 If production - sales $17000 then 35% How do I get the formula to stop at the lower limits of the criteria. Now it just gives me a FALSE answer for anything under $17000. Thanks for your help!! NancyB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF statements | New Users to Excel | |||
| Nested IF statements | Excel Worksheet Functions | |||
| Nested if statements - is there a better way? | Excel Worksheet Functions | |||
| Help with Nested If Statements | Excel Discussion (Misc queries) | |||
| I want to use more than 7 nested if then statements | Excel Worksheet Functions | |||
Threaded Mode
