I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16 is
2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the multiply
the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1 and it's
23.6.

Excel makes it 24.31?

The figures are only a simple example, all the calculations are equally
wrong when this formula is used.

What am I doing wrong. Where is my beer?


--
Dave - The Medway Handyman
www.medwayhandyman.co.uk
01634 717930
07850 597257

The Medway Handyman wrote:
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16 is
2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the multiply
the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1 and it's
23.6.

Excel makes it 24.31?

The figures are only a simple example, all the calculations are equally
wrong when this formula is used.

What am I doing wrong. Where is my beer?


I copied and pasted your formula, entered the values you said and got:

10 2.36 1 23.6

Finger trouble?
--
Rod

Hypothyroidism is a seriously debilitating condition with an insidious
onset.
Although common it frequently goes undiagnosed.
www.thyromind.info www.thyroiduk.org www.altsupportthyroid.org

"The Medway Handyman" wrote in message
m...
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16
is 2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the
multiply the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1
and it's 23.6.

Excel makes it 24.31?

Works fine here. Are B16 or C16 derived from values in other cells? Perhaps
one of the cells has been formatted differently (non numerical?) or perhaps
some severe rounding going on somewhere.


The figures are only a simple example, all the calculations are equally
wrong when this formula is used.

What am I doing wrong. Where is my beer?

Sounds like you've maybe scoffed it all!

In message , The Medway
Handyman wrote
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16 is
2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the multiply
the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1 and it's
23.6.

Excel makes it 24.31?

The figures are only a simple example, all the calculations are equally
wrong when this formula is used.

What am I doing wrong. Where is my beer?




Format cell problem? The '1' may actually be '1.03' but you have
formatted the cell to show zero numbers after the decimal point.?

It may not be the D16 that is incorrectly formatted.
--
Alan
news2006 {at} amac {dot} f2s {dot} com

The Medway Handyman wrote:
I'm confused! Normally good with Excel, but this has got me puzzled.

Doh!

It was a simple formatting error! I'd forgotton I'd formatted B16 to zero
decimal places. The 10 was actually 10.3

:-)

Its been a long day...........

But I've found my beer!!!

Thanks all. Sanity restored.


--
Dave - The Medway Handyman
www.medwayhandyman.co.uk
01634 717930
07850 597257

"The Medway Handyman" wrote in message
m...
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16
is 2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the
multiply the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1
and it's 23.6.

Excel makes it 24.31?


I get 23.6.

Those cheap chinese import versions of Excel arn't as good as the genuine
pirated Microsoft versions.


mark

mark wrote:
"The Medway Handyman" wrote in message
m...
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16
is 2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the
multiply the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1
and it's 23.6.

Excel makes it 24.31?


I get 23.6.

Those cheap chinese import versions of Excel arn't as good as the genuine
pirated Microsoft versions.


And open office is actually BETTER.

mark

On Tue, 11 Mar 2008 21:35:06 -0000
"mark" wrote:


"The Medway Handyman" wrote in message
m...
I'm confused! Normally good with Excel, but this has got me puzzled.

Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16
is 2.36 * D16 is 1.

So, Excel should first perform the multiplication in brackets, the
multiply the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1
and it's 23.6.

Excel makes it 24.31?


I get 23.6.

Those cheap chinese import versions of Excel arn't as good as the genuine
pirated Microsoft versions.


mark



Can't honestly see why anyone would bother pirating Microsoft (The
Anti-Competition Company) Corps stuff. OpenOffice is better, and can
do mailmerge without a nervous breakdown.

R.

TheOldFellow wrote:

snip

Can't honestly see why anyone would bother pirating Microsoft

It makes for a very interesting and satisfying hobby :-)

(The
Anti-Competition Company) Corps stuff. OpenOffice is better, and can
do mailmerge without a nervous breakdown.

Since I don't use any of Office's software, I might take a look at it
when I get some time. Thanks.

Dave