Can anyone tell me what's wrong with this formula?

Can anyone tell me what's wrong with this formula:
=IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D5>24,0,D5))))))))
I get an error message and I do not know why? Please help!

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten

"Linda" <[email protected]> wrote in message news:[email protected]...
> Can anyone tell me what's wrong with this formula:
> =IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D5>24,0,D5))))))))
> I get an error message and I do not know why? Please help!

I don't, but it could be simpler

=IF(OR(D5=517,D5=520,D5=521,D5=522,D5=523,D5=524,D5=567),8,IF(D5>24,0,D5))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Linda" <[email protected]> wrote in message
news:[email protected]...
> Can anyone tell me what's wrong with this formula:
>
=IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(
D5=567,8,IF(D5>24,0,D5))))))))
> I get an error message and I do not know why? Please help!

> =IF(D5=517,8,IF(D5=520,8,IF(D5=521...etc

Would this work?

=IF(OR(D5={517,520,521,522,523,524,567}),8,IF(D5>24,0,D5))

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"Linda" <[email protected]> wrote in message
news:[email protected]...
> Can anyone tell me what's wrong with this formula:
> =IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D5>24,0,D5))))))))
> I get an error message and I do not know why? Please help!

The last part of the formula overides all the other if statements and you
have too many nested if statements, You can only have 7. You could solve this
with a lookup table or here is another way
=IF(OR(D5=517,D5=520,D5=521,D5=522),8,"")
--
thanks

ah


"Linda" wrote:

> Can anyone tell me what's wrong with this formula:
> =IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D5>24,0,D5))))))))
> I get an error message and I do not know why? Please help!

Linda Wrote:
> Can anyone tell me what's wrong with this formula:
> =IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D524,0,D5))))))))
> I get an error message and I do not know why? Please help!

Look at the fifth "IF", there's a space between the "I" and the "F".
Hope this it!
maynard


--
ChE_maynard