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

formula

ResolvedVersion 2003

cindy has attended:
Excel Intermediate course

Formula

How to no when to use () etc

Edited on Thu 17 Apr 2008, 20:47

RE: Formula

Hi Cindy, Thank you for your post, () or Parentheses are basically 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. 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;
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 helps, if so please click the Resolved link, regards Pete.

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.