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

[tennisnut]

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]

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

 

[Pete_UK]

Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete

 

[joel]

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

Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete