excel courses in london - Order of calculations

Resolved · Low Priority · Version Standard

Wed 19 Dec 2007, 16:23 Delegate Brian said...

Brian has attended:
Excel Introduction course

Order of calculations

What does BE,ODMAS stand for?

Thu 20 Dec 2007, 10:52 Trainer Amanda said...

RE: Order of calculations

Hi Brian

Thank you for your question.

BEDMAS or BODMAS is an acroynm designed to help remember the order that Excel will follow when performing a calculation.

Excel will calculate anything inside Brackets first, followed by anything which has an Exponent (or Operator), then Multiplication or Division; and lastly Addition or Subtraction.

For example, in the formula =A1+B1*C1, Excel would multiply the values in cells B1 by C1 first; then add the value in cell A1 to this to get the final result.

I hope this helps; and have a happy Christmas.
Amanda

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

excel courses in london - Order of calculations

Order of calculations

RE: Order of calculations

Excel articles

Excel tip:

Calculate age or service