Can I format a cell to round a number by 50 basis points (0.5)?

D

daveb

I am trying to format a number cell so that the decimal value rounds up to
the next .5. Is this possible? I
 
B

Biff

Hi!

You can't use formatting in that manner but you could use a function.

=CEILING(A1,0.5)

Or, put your current formula inside:

=CEILING(SUM(A1:A10),0.5)

Biff
 
Top