Hi
=Ceilin(A1,0.5)
Also see:
http://www.xldynamic.com/source/xld.Rounding.html
--
Regards
Frank Kabel
Frankfurt, Germany
Santosh Budalakoti wrote:
Dear Concerned,
Please advise how can i round off .10 as .50 and .51 as 1.00 ? The
summary is that how can i round off the figures in a round off of .50.
Waiting for a favourable response from your end.
Regards
Santosh Budalakoti