Thanks for feeding back, Colin.

Pete

On Apr 18, 2:19*pm, Colin Foster
wrote:
Hi Pete,
Bugger!!!! (good technical word, that one!) I'd thought of the ROUND
function, but wrapped around the CEILING, not the obvious answer that you've
come up with!

Ok, so, if I then wanted to also round to 5p, then, I do the round &
subtract 0.05 :-)

Cheers for this... sometimes, you just need to ask the question for someone
else to take the blindfold away!