One way:

A1 = 2.23

=CEILING(A1,0.5)

--
Biff
Microsoft Excel MVP


"Sena" wrote in message
...
Hi, is there a way to round up to the nearest 0.50 ?
eg: 2.23 should be rounded to 2.50 & 2.65 should get rounded to 3.00
--
Cheers !