Re: rounding off numbers with excel
Tech-Archive recommends: Speed Up your PC by fixing your registry
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
--
Greetings from New Zealand
Bill K
"Tom C" <c_tom@xxxxxxxxxx> wrote in message
news:Oxbm9rQ%23FHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
Relevant Pages
- Re: Fastcode RoundTo
... The rounding control could be like the following: ... {Round to nearest else to even digit. ... drHalfOdd, {Round to nearest else to odd digit. ...
(borland.public.delphi.language.basm) - Re: Win32Forth & negative zero
... >>>Round to nearest/even is not necessarily better than others. ... nearest with even tie breakers "IEEE rounding", ... has four rounding modes, labeled in C99 as FE_TONEAREST, ... In particular C99, which I think is getting it right, and ought ...
(comp.lang.forth) - RE: Rounding to nearest .00 or .50
... Then set your textbox control source and/or calculated query field to the ... > a course by dividing the total number of minutes of course instruction by 60 ... > but I need it to round to the nearest .00 which, ...
(microsoft.public.access.forms) - Re: Hillary Clinton Gives Driving Advice
... would have to do would be to round to the nearest $0.1 instead. ... The gov't has tried that on the one with issuing the dollar coin (the ... "When you can't afford the gas to drive to the job ...
(rec.autos.driving) - Re: Burette/Thermom. Readings - Rounding?
... >I realised I don't know how to round values from thermometers, burettes ... then you round DOWN to 20.00; else if it is above the halfway ... >to the upper or lower regions inbetween the divisions. ... You have decided to read to the nearest 5 in the last ...
(sci.chem) |
|
