Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do I convert every cell in a spreadsheet to round to millions | Excel Worksheet Functions | |||
after calculating, round a cell value | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |