D
DC
I am trying to multiply two cells and am getting an incorrect answer. How do
I correct this?
I correct this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Greenblatt
I doubt that anything is wrong and needs correction. However, in order toI am trying to multiply two cells and am getting an incorrect answer. How do
I correct this?
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?
F
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.
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
J
JE McGimpsey
DC said: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.