Ok still not sure and cant get it to work, for example I have (Starting
in A1)

11.47
15.59
14.44

Wanting to round up to teh nearest 5 PENCE

To read in B1 etc

11.50
15.60
14.45

And so on

Cant get my head round it

Regards

M


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