View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erika Erika is offline
external usenet poster
 
Posts: 120
Default 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.