in one cell I have 913 in another cell I have .50 = when I do the calculation
useing cell references the answer I get is 456.30

"Peo Sjoblom" wrote:

If I do

=913*.50

I get 456.50


you probably are formatting to display what's in a cell to 913 and you think
what you see is what you get, copy and paste the cell that display as 913 to
another cell and paste it special and select values, format it as general
and you will see why there is a difference. Remember that formatting does
not change the contents of a cell, only what's displayed

So you can either use ROUND or precision as displayed under
toolsoptionscalculations.

Note that it might affect other calculations


--
Regards,

Peo Sjoblom



"Erika" wrote in message
...
I have to apologize I have done a horrible job explaining my problem.

when I do the following calculation in Excel

913 * .50 the answer I get is 456.30

when I do the same calculation on a calculator
913 * .50 the answer I get is 456.50

Why the difference?

"Mike H" wrote:

Erika,

I assume it's a typo where you say

multiple 912.5 * .50=426.25

becasuse the correct answer is 456.25

The reason you get a different answer when you use Round is thta the
round
finction actually changes he number so it becomes 913 which when
multiplied
by 0.5 gives 456.5

Mike


"Erika" wrote:

I am having problems understanding what is happening with my formulas
depending if I round or not.

If I multiple 912.5 * .50=426.25

if I round
913*.5=456.5

Why are the answers different? I am trying to charge our customers per
driver and I don't think they will agree to pay for .25 or .50 of a
person,
even though I want to show them the entire calculation.