Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Does anyone knows, why the result of Ceil(1092/364) is 4 ??? It should be 3 Or am I wrong?
Seems like rounding error problem
Ceil will round the value when it exceeds (means 3.0003 should result to 4)
If you want 3 as a result you can go with floor(as it takes integer part)
else you can go with round based on requirement.
One work around would be to do this
=Ceil(Round(1092/364, 0.1))
=Ceil(Round(1092/364, 0.00000000001))