How do you round numbers in a range to the nearest quarter so they all end in .00, .25, .50, or .75?
P Pencil Jun 29, 2006 #1 How do you round numbers in a range to the nearest quarter so they all end in .00, .25, .50, or .75?
B Bob Phillips Jun 29, 2006 #2 =ROUND(A1/0.25,0)*0.25 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=ROUND(A1/0.25,0)*0.25 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)