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

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

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

That depends upon what order you want them to be processed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Louise" wrote in message
...
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

A basic example........

My calculation is =10+10*2+2*10

My total should therefore be 420.

Where do the brackets go, and why, in order to get to the right answer???

Louise



"Bob Phillips" wrote:

That depends upon what order you want them to be processed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Louise" wrote in message
...
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

=((10+10)*2+2)*10

Normal arithmatic applies x / + -

If you know how to do it on paper, do the same in Excel

=((10+10)*2+2)*10

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Louise" wrote in message
...
A basic example........

My calculation is =10+10*2+2*10

My total should therefore be 420.

Where do the brackets go, and why, in order to get to the right answer???

Louise



"Bob Phillips" wrote:

That depends upon what order you want them to be processed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Louise" wrote in message
...
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

"Louise" wrote in message
...
"Bob Phillips" wrote:

"Louise" wrote in message
...

"Bob Phillips" wrote:

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

BODMAS

Brackets
Of
Divide
Multiply
Add
Subtract

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.

That depends upon what order you want them to be processed.

A basic example........

My calculation is =10+10*2+2*10

My total should therefore be 420.

Where do the brackets go, and why, in order to get to the right answer???

It looks as if you want
=((10+10)*2+2)*10

It sounds as if, to get what *you* have defined as the right answer, you
want each operation in the order in which they are listed, rather than in
the order of precedence which Bob gave you.
To be on the safe side, you could, if you wish, put brackets round each
operation in turn:
=(((10+10)*2)+2)*10

.... but you can omit the brackets where the conventional order of precedence
doesn't need the brackets (such as where the multiply takes precedence over
the subsequent addition).

If your calculation is really
=10+10*2+2*10
the *right* answer is 50.
--
David Biddulph

Sorry, I meant Order not Of

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