ExcelBanter - round numbers to the nearest quarter?

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

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

- - round numbers to the nearest quarter? (https://www.excelbanter.com/excel-worksheet-functions/26173-round-numbers-nearest-quarter.html)

LeelooIvy

round numbers to the nearest quarter?

How do you round numbers to the nearest quarter?

JE McGimpsey

One way:

=ROUND(A1*4,0)/4

In article ,
LeelooIvy wrote:

How do you round numbers to the nearest quarter?

CLR

Another........
=MROUND(A1,0.25)
or if you're doing pricing you may want
=ROUNDUP(A1*4,0)/4

Vaya con Dios,
Chuck, CABGx3

"JE McGimpsey" wrote in message
...
One way:

=ROUND(A1*4,0)/4

In article ,
LeelooIvy wrote:

How do you round numbers to the nearest quarter?

Dave Peterson

Or even:
=CEILING(A1,0.25)
(for an alternative for the =roundup() sample)

CLR wrote:

Another........
=MROUND(A1,0.25)
or if you're doing pricing you may want
=ROUNDUP(A1*4,0)/4

Vaya con Dios,
Chuck, CABGx3

"JE McGimpsey" wrote in message
...
One way:

=ROUND(A1*4,0)/4

In article ,
LeelooIvy wrote:

How do you round numbers to the nearest quarter?

--

Dave Peterson

All times are GMT +1. The time now is 02:28 PM.