Re: Ending In 5

Tech-Archive recommends: Fix windows errors by optimizing your registry


"JR" <gaspower@xxxxxxx> wrote in message
news:SgNpe.1436$bv7.732@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> I have a column of numbers that end in many different numbers such
> as 7.66, 3.43 ect. I would like to make all the numbers to end in 5.
> Such as 7.65 and 3.45.
>
> Thanks JR,
>
>

Hi JR,

Try this:

ROUND((A1+0.05)/0.1,0)*0.1-0.05


I am assuming you really did mean that you want each answer to end in
a 5 (rather than rounding to the nearest 0.05 which could result in,
say, 3.40.

If you just want to round to the nearest 0.05 then use the formula
posted by Biff.

HTH,

Alan.





.

Relevant Pages