I would like to suggest a change/addition to the way formulas are displayed
when writing them in an excel workbook (not VBA). When writing formulas the
traditional way, it can get quite overwhelming when trying to next many
logical/conditional statemetns in one formula and keep track of which
parenthesis closes which function. Instead of everything thing being written
on one line (ie "=if(a2=a3,a4,if(a2a3,a5,ifa2<a3,a6,"")))" ) that each new
line of logic should drop down a line in the display (much like if you were
writing an 'if' statement in c++ or the like) so that it is easier to discern
which logical statement you are working on when it is complex (much more so
than this simple example). In short, there should be a line break in the
display of the formula while working with it after each 'if' in the example
above.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions