excel courses in london - 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