when do you know

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » When do you know when to use brackets in formulas? | Excel forum

When do you know when to use brackets in formulas? | Excel forum

resolvedResolved · Low Priority · Version 2003

Lorraine has attended:
Excel Intermediate course

When do you know when to use brackets in formulas?

as above

RE: when do you know when to use brackets in formulas?

Hi Lorraine, Welcome to the forum, Thank you for your post, in answer to your question; Consider the Acronym BODMAS when you create a formula, BODMAS = Brackets, Ordinals, Division, Multiplication, Addition, Subtraction - this is the order in which Excel works out a formula's operators; Parentheses aka brackets. Using brackets in your formulas is a good habit to get into even when they are not strictly needed because they help to clarify the order and make the formula easier to understand. It is also possible to put parentheses within parentheses. When parentheses are nested the ones on the inside are evaluated first. When you enter parentheses you will notice that Excel tries to help you by making the matching parentheses bold as you pass over it with the mouse. Your parentheses must balance. For every open parentheses there must be a corresponding close parentheses. If you try to submit a formula which does not contain the same number of open and close parentheses, Excel will prompt you and tell you that the formula you have entered is incorrect. I hope that has made it a little clearer, if so, please click the resolved link, best regards Pete.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.