Thread
:
ROUNDUP IN 0.2 INCREMENTS
View Single Post
#
2
Ron Coderre
Posts: n/a
If none of the values will be negative:
=CEILING(A1,0.2)
If they can be positive or negative and you truly want the value to round up
to a larger value:
=IF(A1<0,-FLOOR(ABS(A1),0.2),CEILING(A1,0.2))
Does that help?
Ron
Reply With Quote