How do i round up a price to the nearest 5,10,15 etc pence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The ROUND function 3
Rounding to price points 6
rounding up to the nearest 1000 1
Alternate Rounding Up & Down of .50 in a column 5
Setting a sale price and rounding up 4
Rounding Time to Nearest 5 Minutes 1
rounding figures to nearest thousand 3
Round to .05 or .09 8

Back
Top