Increase number to next whole number (excel 2003)

Topic

New Reply

Is it possible to increase an answer from a formula to the next whole number? For example, I have a formula that will calculate an estimate …answer could be 1875…I want a formula to increase it to 1900.

Any ideas?

Reply | Quote

Replies

You can use the CEILING function for this. Say you have a formula =SUM(A2:A10) whose result you want to round up to the nearest multiple of 100. You’d change the formula to

=CEILING(SUM(A2:A10),100)

Alternatively, you can use the ROUNDUP function:

=ROUNDUP(SUM(A2:A10),-2)

The -2 means -2 decimal places, which is interpreted as multiples of 100 (-3 would mean multiples of 1000 etc.)

Reply | Quote