Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,I F(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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone tell me what's wrong with this formula?
http://www.cpearson.com/excel/nested.htm
-- Kind regards, Niek Otten "Linda" wrote in message ... 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,I F(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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone tell me what's wrong with this formula?
I don't, but it could be simpler
=IF(OR(D5=517,D5=520,D5=521,D5=522,D5=523,D5=524,D 5=567),8,IF(D524,0,D5)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Linda" wrote in message ... 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,I F(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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone tell me what's wrong with this formula?
=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(D52 4,0,D5)) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "Linda" wrote in message ... 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,I F(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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone tell me what's wrong with this formula?
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,I F(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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone tell me what's wrong with this formula?
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,I F(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel formula calculations are wrong | Excel Worksheet Functions | |||
Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
Wrong answer after using the payment formula in excel | New Users to Excel | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |