Rounding results to nearest quarter (in decimals)

  • Thread starter Thread starter djarcadian
  • Start date Start date
D

djarcadian

I have a formula that results gives results like 22.63. Is there a wa
to get it to round up to the nearest quarter number. For example 22.6
would round up to 22.75 or 133.10 would round up to 133.25.

Is this possible
 
I figured this out-

=ROUND(SUM(G25/2)*4,0)/4

Is there any reason to use the CEILING system instead of this system
 
Hi djarcadian

Noy really. It's just tidier, and does exactly what it was designe
to.

Dominic
 

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

Round time to nearest 15 minutes in decimal format 4
rounding up to nearest specified whole number 1
Round result of sum function to quarter hour 3
Average rounded to nearest 0.50 4
round up to nearest 50p 1
Rounding to the nearest quarter point? 3
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25 2
Round Down to the nearest multiple 2

Back
Top