Always round numbers up

Question
1

I have a calculation and wish to always round the calculated number up. I know there is a ROUND function but that will both round up and round down numbers. I’m not smart enough to combine functions/calculations to achieve this so hoping there is an option out there.
For clarity, the calculation should do the following.
13.1 round up to 14
13.5 round up to 14
13.9 round up to 14 etc

Thanks

1 Like
2

Try something like;

If(var>INTEGER(var),INTEGER(var)+1,INTEGER(var))

3

Hi,

You can also try the CEIL() and FLOOR() functions, which always round numbers up and down respectively.