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

hi
Just wondering if there is an add in available that will ensure I have matching brackets for when I am entering complex functions?
LVL 1
agwalshAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KimputerCommented:
You mean, the colored brackets are not enough? Also, the matching brackets will be bold when you use the cursor to move around.
0
SteveCommented:
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.
0
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 :-)
0
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.

Thanks
Rob H
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
agwalshAuthor Commented:
Answers good..but didn't confirm if there was such an add-in or not :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.