I have a case where I need to divide two numbers and round up to nearest integer and store the result in a calculated field. This is commonly known as a "ceiling" function.
|100 / 10||10||10||10||10|
|18 / 10||1.8||2||1||2|
|12 / 10||1.2||1||1||2|
|3 / 10||0.3||0||0||1|
I can only seem to find a "round" function. Neither the "Floor" og the "Ceiling" is available as far as I can see.
Any ideas on how to overcome this?
Solved! Go to Solution.
I have done the following before:
Take the value you have from division above and do the following:
1. calculate round
2. if round = division ---> set ceiling and floor = division
3. if round > division ---> set ceiling = round, floor = round - 1
4. if round < division ---> set ceiling = round + 1, floor = round
does that make sense?
Also, there's the % operator which gives you the remainder of a division. So 18%10 will return 8. Using the If() you could come up with the calculated value formulas that you're looking for.
For example the below seems to do the trick for me (using result examples from Wikipedia):
The subtraction part is to compensate for negative numbers.
It definately makes sense - thanks for your input. I will have to wrap it in some nested "if/then" structure inside my formula however, since my problem relates to Forms instead of Workflow.