ExcelBanter - If Statement with 9 sequences

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement with 9 sequences (https://www.excelbanter.com/excel-discussion-misc-queries/260889-if-statement-9-sequences.html)

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

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