Microsoft Office excel 2007 - upgrade

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

=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.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History