round up in own cell

Hi Am wondering if there is not a way of rounding up a number in the cell
that the function is in.

thanks tim

Sure. =ROUNDUP((MyFormulaHere),0)

So perhaps something like =ROUNDUP((A2*A3),2)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Tim" <adslk4at@tpg.com.au> wrote in message
news:42b620c4@dnews.tpgi.com.au...
> Hi Am wondering if there is not a way of rounding up a number in the cell
> that the function is in.
>
> thanks tim
>
>

Hi!

Yes, you can do this.

Since you didn't provide any details the only suggestion I can make is to
see Excel help on the Roundup or Ceiling functions.

Biff

"Tim" <adslk4at@tpg.com.au> wrote in message
news:42b620c4@dnews.tpgi.com.au...
> Hi Am wondering if there is not a way of rounding up a number in the cell
> that the function is in.
>
> thanks tim
>

On Mon, 20 Jun 2005 11:49:39 +1000, "Tim" <adslk4at@tpg.com.au> wrote:

>Hi Am wondering if there is not a way of rounding up a number in the cell
>that the function is in.
>
>thanks tim
>

=ROUNDUP(your_function,0)

or you could use the CEILING function if appropriate.

See HELP for both those functions.


--ron