Ceil

[coxanagi]

Hello

Does anyone knows, why the result of Ceil(1092/364) is 4 ??? It should be 3 Or am I wrong?

[sunny_talwar]

Seems like rounding error problem

Rounding Errors

[surendraj]

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.

[sunny_talwar]

One work around would be to do this

=Ceil(Round(1092/364, 0.1))

=Ceil(Round(1092/364, 0.00000000001))