Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Order of calculations
Resolved · Low Priority · Version Standard
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 serviceThe 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: |
We'll call during UK business hours
Server loaded in 0.08 secs.