rounding question

[SueMac]

I have a value 105.5248 which should round up to 105.53 when using the 2 decimal format but it is returning 105.52
Any idea how I can fix this!

[6StringJazzer]

The rounding you are seeing is correct. To round to two decimal digits it is looking at the 4, seeing that it is less than 5, and rounding to 105.52.

[Pete_UK]

The 3rd decmal place is a 4, so normally this would round to 105.52. If you wanted it always to round up, then you could use the ROUNDUP function:

=ROUNDUP(A1,2)

or if you only wanted a certain number of values to round up (eg from 0.xx3) then you could do this:

=ROUND(A1+0.002,2)

Hope this helps.

Pete

[martindwilson]

you can use a formula =ROUNDUP(A1,2)

[contaminated]

Maybe

Please Login or Register  to view this content.

[SueMac]

Thanks Pete, the =ROUND(A1+0.002,2) is what I was looking for