Prev: Excel
Next: Patient Demand on X Day of the Month
From: Daisy77 on 7 Apr 2010 11:01
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
From: Mike H on 7 Apr 2010 11:13
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
From: מיכאל (מיקי) אבידן on 7 Apr 2010 11:17
Usually - with over than 7 nested ifs - you will use a small helper table
from which you will return the appropriate value with the VLOOKUP function.
Excel 2007/2010 allows up to 64 nested ifs but it will be hard to
read/understand.
It is difficult to propose a more direct solution without having all the
details.
Micky


"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
From: Daisy77 on 7 Apr 2010 11:19
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(B15>14669,(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
 | 
Pages: 1
Prev: Excel
Next: Patient Demand on X Day of the Month