• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Is there an add-in to ensure I have matching brackets in complex formulas

Just wondering if there is an add in available that will ensure I have matching brackets for when I am entering complex functions?
2 Solutions
You mean, the colored brackets are not enough? Also, the matching brackets will be bold when you use the cursor to move around.
To aid in reading complex formula you can increase the size of the formula area and use the [ALT] button to "split" the formula into more readable chunks.
See below:
ExampleThis can make it far easier to read complex formula and has no impact on the results of the formula.
agwalshAuthor Commented:
@The_Barman - the person who asked me is an experienced programmer so he's doing the Alt-Enter thing already...I think he was looking for something like a bracket add-in...if such a thing exists :-)
Rob HensonFinance AnalystCommented:
This function is already built in so no need for an Add In.

If you don't have the correct number of brackets, Excel will attempt to correct for you when pressing enter and will tell you what correction has been made.

If a bracket is missing from a particular function within a formula string, excel will interpret the next part of the formula as the next parameter in that function so could produce an error and in doing so won't attempt to correct the formula but will highlight as an error in that function.

Hope that makes sense.

Rob H
agwalshAuthor Commented:
Answers good..but didn't confirm if there was such an add-in or not :-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now