How do you round numbers in a range to the nearest quarter so they all end
in .00, .25, .50, or .75?
How do you round numbers in a range to the nearest quarter so they all end
in .00, .25, .50, or .75?
=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?
>
"Bob Phillips" <[email protected]> wrote in news:ep6H2O1mGHA.2252
@TK2MSFTNGP04.phx.gbl:
> =ROUND(A1/0.25,0)*0.25
>
Thank you>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks