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 Introduction
Resolved · Low Priority · Version 2003
Doreen has attended:
Access Introduction course
Excel Introduction course
Excel Intermediate course
Access Intermediate course
Access Advanced course
Excel Advanced course
What is Bedmas?
Hello Doreen
Thank you for your question and welcome to the forum.
BEDMAS is an acroynm designed to help you remember the order in which Excel will work out the result of a formula for you, if the formula contains more than one kind of operator.
So:
anything in Brackets will be done first; followed by
any Exponents; then
any Division or Multiplication; and finally
any Addition or Subtraction
I hope this helps.
Amanda
Hi Doreen
BEDMAS is a way to remember the Hierarchy Of Calculation in Maths. Since all formulas in Excel must follow this system we need to remember the order in which calculations are conducted.
The letters stand for:
Brackets
Exponent
Division
Multiplication
Addition
Subtraction
This is the order of operations of any formula.
Hope this helps
Carlos
Wed 18 Feb 2009: Automatically marked as resolved.
|
Excel tip:Enter formulae into multiple cellsIf a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell. |
We'll call during UK business hours
Server loaded in 0.08 secs.