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" wrote in message
...
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" wrote in message
...
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" 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