If Statement with 9 sequences
Thanks, it works great!
"Luke M" wrote:
This will work better if you build a lookup table. Lets say its in A2:C9,
looks like:
0 529 .1
943 942 .15
2914 2913 .25
3618 3618 .27
4772 4771 .25
5580 5579 .28
8347 8346 .33
14670 14669 .35
etc...
Your formula then becomes:
=(B15-LOOKUP(B15,A2:B9))*LOOKUP(B15,A2:A9,C2:C9)
This approach has the advantage in that its easier to change your values,
audit formulas, and you can have thousands of possibile choices.
--
Best Regards,
Luke M
"Daisy77" wrote in message
...
sorry this is the formula i have:
=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))))))))
"Mike H" wrote:
Daisy,
maybe we can simplify your nested if, post your formula and the
addition/change you want.
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"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!!!
Thanks!
Daisy
.
|