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