Display Improvement for Writing Formulas
 

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

Display Improvement for Writing Formulas
 

try using alt+enter at the breakpoint desired.
=IF(A2=1,"hi",
IF(A3=2,"low"))

--
Don Guillett
SalesAid Software

"Brian Preston" <Brian wrote in message
...
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