Is there an equivalent to RoundUp() excel formula?

[sorin_mihai]

Hello,

I’m trying to build up some math expressions, but I can only find expressions that take divide operations between two number and Round them to an integer (floor, ceiling). Is there a way to ha a Divide operation between two values and have the result RoundUp the last 2 digits?

(just like RoundUp(10/7,2) = 1.43)

Thank you,
Sorin

[MultiTech]

sorin_mihai:

RoundUp(10/7,2)

Ceiling(10/7,2) should work, you might need to encapsulate the division operation in its own set of parentheses though.

[sorin_mihai]

MultiTech_Visions:

Ceiling(10/7,2) should work

Nope, it doesn’t work

[Aleksi · Accepted solution]

CEILING(100*10/7.2)/100.0 will do that

[sorin_mihai]

Aleksi:

CEILING(100*10/7.2)/100.0 will do that

Smart

[Steve]

See also Virtual columns giving wrong answers.

[sorin_mihai]

Steve:

See also Virtual columns giving wrong answers .

I was lucky, I did have a decimal column part in the formula but really good to know, thank you