View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.