I have a value in one cell that is derived from a formula. In another cell i
want to take that value and round it up in increments of five.

Can you give us an example of the data? And when you say round it up in
increments of 5 I'm not sure what you mean, what is the number you are
working with and what do you want to see.

"lpp123" wrote:

I have a value in one cell that is derived from a formula. In another cell i
want to take that value and round it up in increments of five.

Try this:

=CEILING(A1,5)

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554724

It don't get much simplier than that..........good one Bearacade!

Vaya con Dios,
Chuck, CABGx3



"Bearacade" wrote:


Try this:

=CEILING(A1,5)

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554724