Mac Forum / Applications / Excel / May 2008

On 5/21/08 11:13 AM, in article
5C8DA0C5-C008-4F56-B94B-09218F2A65AA@microsoft.com, "DC"

I doubt that anything is wrong and needs correction. However, in order to
help you we need to know: what version of Excel? What are the contents of
the 2 cells and where are they (cell address)? What formula are you using to
multiply them? What is the answer you get? Why do you think it is wrong?

How are you getting the wrong answer? How are you going about it?

Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

On 5/21/08 8:13 AM, in article
5C8DA0C5-C008-4F56-B94B-09218F2A65AA@microsoft.com, "DC"

You haven't replied to Bob or Fergal, so I can't add anything
definitive, but the most common source of "wrong" answers is not
understanding that XL uses the values *stored* in the cells in
calculations, not the value *displayed*.

So if you have

A1:      =1/3

displayed with 2 decimal places:

        0.33

and then you use that in a calculation:

B1:      =A1*6

the displayed result will be 2.00, not 1.98.