| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement with 9 sequences.. problem
Hello everybody,
I currently have an IF statement w/8 sequences and it is working properly. I'm doing this for tax purposes. When I try to add one more sequence, it doesn't work. basically I just want to say If B4<529,0. I want it to return a value of zero if cell B4 is < 529. This is my current formula: =IF(B15<943,(B15-529)*0.1,IF(B15<2914,(B15-942)*0.15,IF(B15<3618,(B15-2913)*0.25,IF(B15<4772,(B15-3617)*0.27,IF(B15<5580,(B15-4771)*0.25,IF(B15<8347,(B15-5579)*0.28,IF(B15<14670,(B15-8346)*0.33,IF(B1514669,(B15-14669)*0.35,0)))))))) Please help!!! Thanks! Daisy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement with 9 sequences | Excel Discussion (Misc queries) | |||
| If Statement with 9 sequences | Excel Discussion (Misc queries) | |||
| Restricted value sequences in rows | Excel Worksheet Functions | |||
| Save as: sequences? | Excel Discussion (Misc queries) | |||
| paste sequences of different lengths | Excel Worksheet Functions | |||
Threaded Mode
