round numbers to the nearest quarter?

C

CLR

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
Round numbers to get to the nearest 0.09 7
formula/version 2007 2
Round time to nearest quarter hr 2
ROUND TIME TO NEAREST QUARTER HOUR 3
Rounding a sum to the quarter hour. 3
rounding up to the nearest 1000 1
Rounding in the Same Cell 2

Top