ExcelBanter - Rounding to the nearest quarter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding to the nearest quarter (https://www.excelbanter.com/excel-worksheet-functions/156494-rounding-nearest-quarter.html)

pdberger

Rounding to the nearest quarter

If I have the results of a calculation in cell A1, how do I round that to the
nearest quarter?
Thanks in advance.

Rounding to the nearest quarter

simplest way is
=round(A1*4,0)/4
if you want, you can format it to always show 2 decimal places

"pdberger" wrote:

If I have the results of a calculation in cell A1, how do I round that to the
nearest quarter?
Thanks in advance.

David Biddulph[_2_]

Rounding to the nearest quarter

=mround(A1,0.25)
--
David Biddulph

"pdberger" wrote in message
...
If I have the results of a calculation in cell A1, how do I round that to
the
nearest quarter?
Thanks in advance.

All times are GMT +1. The time now is 04:40 AM.