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

[lpp123]

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.

[tim m]

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.

[Bearacade]

Try this:

=CEILING(A1,5)

HTH

[CLR]

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
>
>