Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
identify nested parentheses
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Numbers in Parentheses | Excel Discussion (Misc queries) | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |