Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel
Resolved · Low Priority · Version 2003
Reply Tue 16 Dec 2008, 17:00Delegate Carrie-anne said...
Carrie-anne has attended:
Excel Intermediate course
Excel Advanced course
Time Management course
Excel
more info on bodmas
For upcoming training course dates see: Pricing & availability
RE: excel
Hi Carrie-Anne'
Thank you for your question:
In reply;
B = Brackets (Parenthesis)
O= Ordinals (To the power of ie 2^2 = 4)
D= Division
M= Multiplication
A= Addition
S= Subtraction
This is the sequence that Excel will follow when executing a formula; for example 1+2x3 = would be expected to equal 9
however Excel will return the answer 7, this is because it will execute the formula according to BODMAS ie 2x3 =6 + 1 = 7
Can you see the problem.. to sort this the formula would have to read =(1+2)x3 then the portion inside the brackets would be completed first ie 1+2 =3 x 3 = 9
I hope that has helped...Pete
|