ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why can't you use brackets, braces like parenthesis in Excel? (https://www.excelbanter.com/excel-programming/342932-why-cant-you-use-brackets-braces-like-parenthesis-excel.html)

Serendipian

Why can't you use brackets, braces like parenthesis in Excel?
 
Traditionally, when writing math expressions with nested parenthesis it is
often traditional to express the nesting by judiciously replacing paired
parenthesis with paired brackets and/or braces for clarity, e.g. {... [...
(... )... ]... }. As a suggestion, Excel should be able to detect nested
expressions and replace it with this more legible scheme as an aid to error
detection.

JMB

Why can't you use brackets, braces like parenthesis in Excel?
 
Excel already uses brackets [ ] for the workbook name in a linked cell and
braces { } indicate an array.

I think using these for as subs for ( ) would make things more confusing.

"Serendipian" wrote:

Traditionally, when writing math expressions with nested parenthesis it is
often traditional to express the nesting by judiciously replacing paired
parenthesis with paired brackets and/or braces for clarity, e.g. {... [...
(... )... ]... }. As a suggestion, Excel should be able to detect nested
expressions and replace it with this more legible scheme as an aid to error
detection.



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com