For that you can just use Ceiling.Math function.
Ex:
=CEILING.MATH(A2,1/20)
EDIT: Oh wait. I misread. Should be FLOOR.MATH
=FLOOR.MATH(A2,1/20)
For that you can just use Ceiling.Math function.
Ex:
=CEILING.MATH(A2,1/20)
EDIT: Oh wait. I misread. Should be FLOOR.MATH
=FLOOR.MATH(A2,1/20)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks