Order of calculation
hello, thank you for your reply.
Unfortunately, this doesn't really help me. I am already aware of the
actual order, what I am unsure of is where the different sets of brackets go
when the calculation contains more than two operators.
Louise
"Bob Phillips" wrote:
BODMAS
Brackets
Of
Divide
Multiply
Add
Subtract
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Louise" wrote in message
...
Does anybody know of a good website which has examples of the way in which
Excel performs calculations when there is more than one operator in the
calculation? I understand the brackets go around the 'easy' bit, in order
to
tell Excel to do that bit first, but if the calculation has more than 2
operators, I don't know where the other sets of brackets go.
Any help would be appreciated.
Thank you.
Louise
|