View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default identify nested parentheses

If you click on the formula in the formula bar, it will highlight the
differing parentheses and the references in the sheet by colour.

--
Ian
--
"HowEZ" wrote in message
...
When creating nested formulas, it is not easy to identify paired
parentheses
(i.e., you have to count the number of parentheses on each side to see if
you
have an error in the placement of the parentheses, which can change the
formula's result). I believe that, by adding a unique identifier to each
pair, the formula would be much easier to evaluate.

An example of this is to break each parenthesis in the center and place a
small (font size 5 or 6) number in the center of each parenthesis line.
This
would allow for much faster editing of an equation by making it easier to
identify matched parentheses.

----------------
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