Calculations with decimals
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.
|