The cell containing 913 is probably 912.6 but as you appear to have formatted
the cell as 0 decimal places it displays as 913.

Format the cell contain 913 with 2 decimal places.

"Erika" wrote:

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?


"Jock" wrote:

In the first calc, it's essentialy ½ of 912.5 which would be 456.25
In the second that calc is essentially ½ of 913 which is 456.5

hth
--
Traa Dy Liooar

Jock


"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.