Bernard, Thanks very much - that is marvellous!

RMB

"Bernard Liengme" wrote:

How's this =ROUNDUP(A1*2,0)/2
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rmb4253" wrote in message
...
I am trying to round up a number to what I recall from school days to be
"correct to the nearest half". In other words, if the cell value is
between
3.01 and 3.49 I want to round it to 3.5. If the cell value is 3.5 to 3.99
I
want it rounded to 4.0

I have managed to round up and down to the nearest whole number but can't
figure out how to get it to the nearest half! Can anyone help, please?
RMB