How can I round UP to to the next ,50?
 

E.g. 2,3 should become 2,50
2,6 should become 3,00
6,51 should become 7,00
etc...

Vincent

Try this

=CEILING(A1,0.5)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Vincent" wrote in message
...
E.g. 2,3 should become 2,50
2,6 should become 3,00
6,51 should become 7,00
etc...