Force round up

simonlee11

Member
Licensed User
Longtime User
Is it possible to force a number to round up. As an example if the answer is 1.3 can I force this to be 2.


Thanks
 

kickaha

Well-Known Member
Licensed User
Longtime User
To quote the documentation:

Ceil (Number As Double) As Double
Returns the smallest double that is greater or equal to the specified number and is equal to an integer.
 
Upvote 0
Top