Excell- a value in a cell, round it up by fives in another cell
 

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.

Excell- a value in a cell, round it up by fives in another cell
 

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.

Excell- a value in a cell, round it up by fives in another cell
 

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

Excell- a value in a cell, round it up by fives in another cel
 

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