T Tim Jun 20, 2005 #1 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 Am wondering if there is not a way of rounding up a number in the cell that the function is in. thanks tim
A Anne Troy Jun 20, 2005 #2 Sure. =ROUNDUP((MyFormulaHere),0) So perhaps something like =ROUNDUP((A2*A3),2) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
Sure. =ROUNDUP((MyFormulaHere),0) So perhaps something like =ROUNDUP((A2*A3),2) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
B Biff Jun 20, 2005 #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
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
R Ron Rosenfeld Jun 20, 2005 #4 Hi Am wondering if there is not a way of rounding up a number in the cell that the function is in. thanks tim Click to expand... =ROUNDUP(your_function,0) or you could use the CEILING function if appropriate. See HELP for both those functions. --ron
Hi Am wondering if there is not a way of rounding up a number in the cell that the function is in. thanks tim Click to expand... =ROUNDUP(your_function,0) or you could use the CEILING function if appropriate. See HELP for both those functions. --ron
