rounding off numbers with excel

  • Thread starter Thread starter Tom C
  • Start date Start date
T

Tom C

If i have a number such as 19.57, how can i get Excel (Office XP) to round
it off to the nearest 100th. To where it would be 19.55 or if the number was
19.58, i would want it to round up to 19.60.
Thanks for the help...Tom
 
Hi TOm

That's not 100th, it's 20th. With your number in A1, formula in B1:
=ROUND(A1/5,2)*5

HTH. Best wishes Harald
 
=ROUND(A1*20,0)/20

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Looks like you want to round to the nearest 5 cents

If A1 is the number enter in B1.................
=ROUND(A1/0.05,0)*0.05

format B1 as number with two decimals
 
I appreciate ya'lls help. Let me explain a l;ittle deeper so I will know
where to put this formula. I dont want to mess up my spread sheet, i am
kinds new to formulas.
I am doing a preadsheet for my gas mileage.
I have a column with the gallons used, i'll call that cell B-215
I have a column with the Price per gallon, cell F-215
In cell G-215 i wrote a formula that goes like this =B215*F215
That formula multiplies the cells and gives me the dollar amount, but i also
would like it to round it off up or down to the nearest nickle.
Can i have the round formula with my multiplying formula or do i need to use
another cell for a formula. I hope this makes since,,and i do appreciate the
help.....Tom
 
I really appreciate the help, and I hate to be so bothersome, but could you
help me break this down
I know it is multiply B215 X F215. and I am guessing divide that by .05
which is 5 cents? What is the ,0 and the *0.05
 
the /0.05 changes it to units of 5 cents, the number of 5 cents in the
amount
the , 0 rounds that number to 0 decimal; places
the *0.05 returns it to original units

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top