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

[Linda]

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!

 

[Niek Otten]

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

 

[Bob Phillips]

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)

 

[Dana DeLouis]

=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))

 

[ah]

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,"")

 

[ChE_maynard]

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