How can I Round up to the nearest .25

[Dr. Darrell]

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]

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

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

 

[Mike H]

Try this

=ROUNDUP(B3/0.25,0)*0.25

Drag right

Mike

 

[AnotherNewGuy]

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

The above works on your examples, but test thoroughly before committing to
it ;o)

 

[AnotherNewGuy]

Oops! Make that
=ROUND((4*A1)+0.499,0)/4

 

[RagDyer]

Try this:

=CEILING(A1,0.25)

 

[Brad]

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

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

Brad

 

[T. Valko]

Try this:

=CEILING(B3,0.25)

 

[Lars-Åke Aspelin]

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?

Try this:

=CEILING(B3,0.25)

Hope this helps / Lars-Åke

 

[Shane Devenshire]

Hi,

You can use just about any rounding function to do this:

=ROUNDUP(A3*4,)/4
=ROUND((4*A3)+0.49,)/4
=ROUNDDOWN(A3*4,)/4+1/4
=IF(MROUND(A3,1/4)>A3,,1/4)+MROUND(A3,1/4)

 

[Dr. Darrell]

Thank you all. I have tried a few of these and they work. I will try more
later.

 

[Shane Devenshire]

Hi,

You can shorten the MROUND example in my previous post to

=(MROUND(C1,1/4)<=C1)/4+MROUND(C1,1/4)

It still far and away the longest example.