Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by brothertruffle880
at 2024-07-03 01:28:48
ModifyPoint:500 Replies:9 POST_ID:828931USER_ID:11832
Topic:
Microsoft Excel Spreadsheet Software;;
How many levels of nested if tests can I program?
Can you get me a link that shows an official answer --if there is one.
Can you get me a link that shows an official answer --if there is one.
Author: brothertruffle880 replied at 2024-07-07 07:09:28
That's the number I was looking for. Thanks!
Expert: Glenn Ray replied at 2024-07-03 10:17:31
I concur. :-)
Expert: aikimark replied at 2024-07-03 10:16:51
@Glenn
I agree that the posted question has been answered. However, I'm taking whatever brief contact time I have with brothertruffle880 to suggest that many nested IF statements might be a bad idea and worth further consideration.
I agree that the posted question has been answered. However, I'm taking whatever brief contact time I have with brothertruffle880 to suggest that many nested IF statements might be a bad idea and worth further consideration.
Expert: Glenn Ray replied at 2024-07-03 10:10:13
The question wasn't how to create nested IF statements, or whether it is good practice to use them, or how is performance affected by nested statements. Just how many can one use.
Simple as it may be, Rgonzo1971 answered the question exactly.
But if the questioner wants to open a new question regarding any of the above, I'm willing to jump in. :-)
-Glenn
Simple as it may be, Rgonzo1971 answered the question exactly.
But if the questioner wants to open a new question regarding any of the above, I'm willing to jump in. :-)
-Glenn
Expert: aikimark replied at 2024-07-03 07:22:28
@brothertruffle880
Just because you can do something does not mean that you should do that thing. I think you should describe the problem you are trying to solve and ask us for the simplest solution -- one that does not involve severely nested IF statements.
Just because you can do something does not mean that you should do that thing. I think you should describe the problem you are trying to solve and ask us for the simplest solution -- one that does not involve severely nested IF statements.
Expert: Rob Henson replied at 2024-07-03 04:55:07
There are alternatives to nested IF statements.
Lookup tables, sumifs to name 2.
Thanks
Rob H
Lookup tables, sumifs to name 2.
Thanks
Rob H
Expert: duncanb7 replied at 2024-07-03 02:19:09
Rgonzo1971 is totally right.
I missed this question is related to Excel 2010 (I thought it is 2003)
From the following link, it also mention
Version in 2003 or earlier , it is 7
Version in 2007 or later, it is 64
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/using-more-levels-of-nesting-than-are-allowed/0d743c98-4f85-4b03-ab98-1ea8787e8c7c
Duncan
I missed this question is related to Excel 2010 (I thought it is 2003)
From the following link, it also mention
Version in 2003 or earlier , it is 7
Version in 2007 or later, it is 64
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/using-more-levels-of-nesting-than-are-allowed/0d743c98-4f85-4b03-ab98-1ea8787e8c7c
Duncan
Accepted Solution
Expert: Rgonzo1971 replied at 2024-07-03 02:02:08
500 points EXCELLENT
Hi,
since 2007 it should be 64
http://msdn.microsoft.com/en-us/library/ff700514(v=office.14).aspx
Regards
since 2007 it should be 64
http://msdn.microsoft.com/en-us/library/ff700514(v=office.14).aspx
Regards
Expert: duncanb7 replied at 2024-07-03 01:47:34
This is 7 mentioned from the link
http://www.techonthenet.com/excel/formulas/if_nested.php
Hope understand your question completely. If not, please point it out
Duncan
http://www.techonthenet.com/excel/formulas/if_nested.php
Hope understand your question completely. If not, please point it out
Duncan
