help with rounding up to whole integer
 

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

help with rounding up to whole integer
 

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

help with rounding up to whole integer
 

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

help with rounding up to whole integer
 

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