Round to nearest tenth

collabxchange · Post by **collabxchange** » Mon Nov 17, 2014 10:19 am

Hi,
I searched the forum but couldn't get any answer. Does anyone know how to round a number to nearest equal to higher tenth.

e.g.

12 --> 20
15 --> 20
1.4 --> 10

Thanks!

chulett · Post by **chulett** » Mon Nov 17, 2014 1:12 pm

Hmmm... mod? Mod by 10 and then add the remainer? Decimal values you may need to round up first, me thinks.

ArndW · Post by **ArndW** » Mon Nov 17, 2014 2:18 pm

Code: Select all

INT((In.Column+10)/10)*10

or

Code: Select all

(10-MOD(In.Column,10))+In.Column

to name just two methods

FranklinE · Post by **FranklinE** » Mon Nov 17, 2014 3:45 pm

I use the "Ceil" mathematical function for decimal values, and you should see good results from this:

Code: Select all

(Ceil(In.column/10))*10