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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Round down if decimal 0.33 or below up if 0.34 or above (https://www.excelbanter.com/excel-discussion-misc-queries/228635-round-down-if-decimal-0-33-below-up-if-0-34-above.html)

tennisnut

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

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

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

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

"tennisnut" wrote:

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

Pete_UK

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

Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete

On Apr 23, 11:11*am, tennisnut
wrote:
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

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

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

"Pete_UK" wrote:

Another one:

=ROUND(A1+0.1699999,0)

Hope this helps.

Pete

On Apr 23, 11:11 am, tennisnut
wrote:
Is there a formula that allows you to choose where to round up and down from.
EG 1.33 = 1 and 1.34 = 2

All times are GMT +1. The time now is 04:59 PM.