Fri 12 Dec 2008, 11:26Delegate Hend said...
Hend has attended:
Excel Introduction course
Excel Intermediate course
Word Intermediate course
Word Advanced course
Exell
what is the order of calculation rule for the formula:
A1+B1*C1
Fri 12 Dec 2008, 17:38
Edited on Fri 12 Dec 2008, 17:40Trainer Pete said...
RE: exell
Hi Hend,
Thank you for the question;
In answer; follow the acronym
BODMAS this will give you the sequence that Excel follows in processing a formula.
B=Brackets (Parenthesis)
O=Ordinals (To the power of ^)
D=Division
M=Multiplication
A=Addition
S=Subtraction
So therefore the sequence would be =B1*C1 then +A1
I hope that has helped ... Pete
