Check the help for the ceiling function. It will probably do what you want.

"Millsy" wrote:

Looking for a formula in which i can use to round up prices to the nearest
5,10 pence etc as i have thousands of prices which need to be rounded up to
the nearest 5 pence, and need sum/formula which i can use. Please help and
advise if you can.

Kindest Regards