| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested If Statement Workaround
Hi all,
Can anyone assist me with a workaround for the following formula. As you will be able to see it will not work because of the limit of 8 nested if statements, but I was hoping someone knew of something that would work without me using two different cells. The formula is =if(B16<=29,0.099,if(b16<=34,0.111,if(b16<=39,0.13 7,if(b16<=44,0.2,if(b16<=49,0.3,if(b16<=54,0.675,i f(b16<=59,0.852,if(b16<=64,1.405,if(b16<=69,2.389, if(b16<=74,3.869,if(b16<=79,6.451,0))))))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested "IF" Statement | Excel Worksheet Functions | |||
| Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
| :confused: Nested if then else statement | Excel Worksheet Functions | |||
| Nested IF Statement Question | Excel Discussion (Misc queries) | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
Threaded Mode
