Giving Incorrect Answer

[DC]

I am trying to multiply two cells and am getting an incorrect answer. How do
I correct this?

 

[Bob Greenblatt]

I am trying to multiply two cells and am getting an incorrect answer. How do
I correct this?

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?

 

[Fergal Condron]

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.

 

[JE McGimpsey]

I am trying to multiply two cells and am getting an incorrect answer. How do
I correct this?

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.