How do I roundup the value of a formula

Microsoft Office excel 2007 - upgrade
February 3, 2011 at 07:14:12
Specs: Windows XP
If I divide cell A1 by B1 and display the answer in C1. This answer must always round up to the nearest whole number, never down. Thanks

See More: How do I roundup the value of a formula

Report •

#1
February 3, 2011 at 10:57:17
=ROUNDUP(your_formula, num_digits)

Read up on the ROUNDUP function in the Excel Help files. Where it says number, substitute your formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question