ExcelBanter - how do I round 3.30 to the nearest quarter. 3.30=3.25

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

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

- - how do I round 3.30 to the nearest quarter. 3.30=3.25 (https://www.excelbanter.com/excel-worksheet-functions/72773-how-do-i-round-3-30-nearest-quarter-3-30%3D3-25-a.html)

pat canning

how do I round 3.30 to the nearest quarter. 3.30=3.25

Bob Phillips

how do I round 3.30 to the nearest quarter. 3.30=3.25

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"pat canning" <pat wrote in message
...

via135

how do I round 3.30 to the nearest quarter. 3.30=3.25

=MROUND(3.3,0.25)

-via135

pat canning Wrote:

--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=514472

All times are GMT +1. The time now is 09:50 PM.