| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement with 9 sequences
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. Please help!!! This is the current formula I have: =IF(B15<943,0,IF(B15<2914,41.3,IF(B15<3618,336.95, IF(B15<4772,512.95,IF(B15<5580,842.53,IF(B15<8347, 1026.53,IF(B15<14670,1801.29,IF(B15<30000,3887.88, 0)))))))) Thanks! Daisy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement with 9 sequences
Sorry, this is a Duplicate posting. My computer wasn't updated so I didn't
realize I resent it multiple times. I already have my answer! Thanks! "Daisy77" wrote: 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. Please help!!! This is the current formula I have: =IF(B15<943,0,IF(B15<2914,41.3,IF(B15<3618,336.95, IF(B15<4772,512.95,IF(B15<5580,842.53,IF(B15<8347, 1026.53,IF(B15<14670,1801.29,IF(B15<30000,3887.88, 0)))))))) Thanks! Daisy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement with 9 sequences | Excel Discussion (Misc queries) | |||
| running number sequences | Excel Discussion (Misc queries) | |||
| Help needed on generating sequences | New Users to Excel | |||
| Save as: sequences? | Excel Discussion (Misc queries) | |||
| paste sequences of different lengths | Excel Worksheet Functions | |||
Linear Mode
