Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 26th 06, 09:36 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default 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   Report Post  
Old August 26th 06, 09:47 AM posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Negative Numbers in Parentheses tiggy2 Excel Discussion (Misc queries) 2 August 16th 06 02:26 PM
Nested IF statement with VLOOKUP James Hamilton Excel Discussion (Misc queries) 1 August 16th 06 07:46 AM
Nested Subtotals in Excel 2002 KG Excel Discussion (Misc queries) 2 September 10th 05 11:51 AM
Why are my nested sub-totals are displaying incorrectly? chiefdean13 Excel Discussion (Misc queries) 1 July 20th 05 05:45 AM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 03:34 PM


All times are GMT +1. The time now is 01:36 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017