Rounding Problem

  • Thread starter Thread starter Keith Blake
  • Start date Start date
K

Keith Blake

I am making a spread sheet for my golf handicap and I am stuck with a
rounding prob....

If I enter the formula =ROUND(J30,0.5) it will return 5 for 5.4 (and
below) or 6 for 5.6 (and above) which is correct and what I want.
But what I need it to do is if I get an answer of say 5.5 I want it to stay
as 5.5
So really what I want it to do is to round up (or down) in increments of .5

Thanks for the help
(AGAIN!)
Keith
 
Depends on whether you want what you said or what you did (they are not
the same).

To round in increments of 0.5, you can use Frank's formula or the
=MROUND(J30,0.5) function from the Analysis ToolPak. This would round
5.3 to 5, contrary to your example

If, per your example, you want to round to the nearest 1 unless the
number is half-way between whole numbers, then you would use
=IF(ABS(J30-ROUND(J30,0))=0.5,J30,ROUND(J30,0))
You could extend this to numbers that display as ?.5 when displayed with
one decimal place by using
=IF(ABS(A1-ROUND(A1,0))>=0.45,MROUND(A1,0.5),ROUND(A1,0))

Jerry
 
Thanks all for the replies....
I went with Franks solution, Dave yours worked well too...
Jerry sorry after re-reading my post it is in-correct but you guys were up
to the task of working it out ..

Thanks
Keith
 
Back
Top