Round down if decimal 0.33 or below up if 0.34 or above

tennisnut · Apr 23, 2009

Is there a formula that allows you to choose where to round up and down from.
EG 1.33 = 1 and 1.34 = 2

joel · Apr 23, 2009

=if(mod(A1,1)<=.33,int(A1),Int(A1)+1)

Pete_UK · Apr 23, 2009

Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete

joel · Apr 23, 2009

Better
=ROUND(A1+(1/6),0)

Pete_UK said:
Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete