Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Order of calculations

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel courses in london - Order of calculations

Resolved · Low Priority · Version Standard

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

Brian has attended:
Excel Introduction course

Order of calculations

What does BE,ODMAS stand for?

For upcoming training course dates see: Pricing & availability

Reply Thu 20 Dec 2007, 10:52Trainer 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 articles

· So Can You Really Sort On Colours In Excel 2007?
· How Are Dates Stored In Excel?
· Understanding XML Within Excel
· Microsoft Excel Features and Functions for Accountants
· Working Together Is Easier Than Ever With Excel 2010

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips