Rounding Up of Decimal Numbers

Copper Contributor

I have a list of values, each ending with a decimal.  

I do understand Excel's rounding Up or Down functionality, but in this case, I need to round up all decimals to the next higher whole number, even from decimals as little as 0,00001.

Is there a method in achieving this?

2 Replies

@JohannFou 

=ROUNDUP(D3,0)

Does this return the intended result?

round.JPG 

@JohannFou 

@OliverScheurich's formula should do what you want. As an alternative:

 

=CEILING.MATH(D3, 1)