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
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