Rounding to nearest quarter

[Pencil]

How do you round numbers in a range to the nearest quarter so they all end
in .00, .25, .50, or .75?

[Bob Phillips]

=ROUND(A1/0.25,0)*0.25

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pencil" <[email protected]> wrote in message
news:[email protected]...
> How do you round numbers in a range to the nearest quarter so they all end
> in .00, .25, .50, or .75?
>

[Pencil]

"Bob Phillips" <[email protected]> wrote in news:ep6H2O1mGHA.2252
@TK2MSFTNGP04.phx.gbl:

> =ROUND(A1/0.25,0)*0.25
>

Thank you>