help with rounding up to whole integer

How do I make a formula (within the same cell) round to the nearest 5?

Thanks - Kim

One way:

=ceiling(a1,5)
or
=ceiling(yourformulahere,5)

kjcramp wrote:
>
> How do I make a formula (within the same cell) round to the nearest 5?
>
> Thanks - Kim
>
> --
> kjcramp
> ------------------------------------------------------------------------
> kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753
> View this thread: http://www.excelforum.com/showthread...hreadid=531548

--

Dave Peterson

The second choice with the formula works, although it rounds up if there is any value behind the decimal at all, but it's close enough.

Thanks again!

Sorry, I misread the question...

Maybe...

=ROUND(A1/5,0)*5
or
=ROUND(YourFormulaHere/5,0)*5



kjcramp wrote:
>
> The second choice with the formula works, although it rounds up if there
> is any value behind the decimal at all, but it's close enough.
>
> Thanks again!
>
> --
> kjcramp
> ------------------------------------------------------------------------
> kjcramp's Profile: http://www.excelforum.com/member.php...o&userid=32753
> View this thread: http://www.excelforum.com/showthread...hreadid=531548

--

Dave Peterson