ExcelBanter - How can I Round up to the nearest .25

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I Round up to the nearest .25 (https://www.excelbanter.com/excel-discussion-misc-queries/214948-re-how-can-i-round-up-nearest-25-a.html)

Brad

How can I Round up to the nearest .25

Multiple by 4, round to nearest whole number, and then divide by 4.

=ROUND((A1*4),0)/4

--
Brad

"Dr. Darrell" wrote:

How can I Round up to the nearest .25.

I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79.
I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00,
4.50, 5.00).

Is there a function for this?

Brad

How can I Round up to the nearest .25

Sorry, I missed the round UP part. It should have been:

=ROUNDUP((A1*4),0)/4

Brad

"Brad" wrote:

Multiple by 4, round to nearest whole number, and then divide by 4.

=ROUND((A1*4),0)/4

--
Brad

"Dr. Darrell" wrote:

How can I Round up to the nearest .25.

I have Cells B3 thru G3 with Values: 3.02, 3.41, 3.65, 3.91, 4.29, and 4.79.
I would like them rounded up to the nearest .25 (3.25, 3.50, 3.75, 4.00,
4.50, 5.00).

Is there a function for this?

All times are GMT +1. The time now is 02:30 AM.