round numbers to the nearest quarter?

  • Thread starter Thread starter Guest
  • Start date Start date
Another........
=MROUND(A1,0.25)
or if you're doing pricing you may want
=ROUNDUP(A1*4,0)/4

Vaya con Dios,
Chuck, CABGx3
 

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

Rounding to the nearest quarter 2
formula/version 2007 2
Rounding in the Same Cell 2
Rounding a sum to the quarter hour. 3
rounding up to the nearest 1000 1
Round numbers to get to the nearest 0.09 7
Round time to nearest quarter hr 2
Rounding number to the nearest quarter 1

Back
Top