Formulas

Hi Duane,

Thank you for your question.

BODMAS is the order of calculations a computer or calculator uses when presented with a formula that has multiple operators. The letters stand for Brackets, Order of, Division, Multiplication, Addition and Subtraction.

If we take the following example:

=A1+B1*C2/D1

Excel will calculate the Division first followed by the multiplication and finally the Addition.

If we use some numbers:

=2+3*3/2

1. 3/2 = 1.5 - Division
2. 3*1.5 = 4.5 - Multiplication
3. 2+4.5 = 6.5 - Addition

So the answer would be 6.5. If you put brackets around the 2+3 the answer would be 7.5.

1. (2+3) = 5 - Brackets
2. 3/2 = 1.5 - Division
3. 5*1.5 = 7.5 - Multiplication

I hope this answers your question.

Regards

Simon