did you try to use ROUND?

regards

"milsupport" escreveu:


I am trying to round currency figures up and down to the nearest
5pence/10pence etc etc How do I round up to these. What is the formula
I need to use. Please Help!!


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800