Rounding Up to Nearest 1/4 Decimal

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

Guest

Hello. How do I round up to the nearest quarter decimal place? i.e. The value 5.71 should be 5.75 and 5.76 should be 6.0.
 
=CEILING(A1,0.25)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Rosie said:
Hello. How do I round up to the nearest quarter decimal place? i.e. The
Click to expand...
value 5.71 should be 5.75 and 5.76 should be 6.0.
 

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 up to the nearest 1000 1
fractions 3
Decimals Constant to 0.50 or Nearest Integer 3
formula/version 2007 2
Alternate Rounding Up & Down of .50 in a column 5
Rounding (decimal) elapsed time 2
Rounding Time to Nearest 5 Minutes 1
ROUNDING NUMBERS 3

Back
Top