|
|
If you're making a suggestion to MS, this isn't the right place - send a
message to instead (this is a peer-to-peer
newsgroup).
Generally, if you're having to nest more than 2, possibly 3, deep, there
are better ways to handle the situation - either through math (for
strictly numeric solutions) or via lookup tables. Most "power users" I
know severely limit their nested IF() functions, other than, say,
wrapper functions that test initial conditions, e.g.:
IF(A1="","",IF(...)).
Nested IF's are notorious for making spreadsheets difficult to
debug/modify, since they often hard-code data that will change from time
to time. And, as you've stated, they can be typographically confusing.
In article ,
"Erik Neu" <Erik wrote:
I would say I'm a low-level Excel poweruser (say, 8 on a scale of 10). I have
no problem writing an IF statement, andsometimes I even write nested IF
statements. But they are HELL to debug. Ioften find myself wishing that Excel
had a rudimentary editor to show them asindented and blocked for human
readability.
|