Say a railing can have a maximum of 1.5m between posts and the railing is 5m long. Then there should be 4 posts.
I need a function like ROUNDUP(5/1.5) = 4.
The round function will give ROUND(5/1.5) = 3.
Is there a way of doing this?
Ok, I think I have it:
CEILING(5/1.5) = 4
1 Like