Round() function for integer

[leesonghyunJNSUP]

Simply, I want to make the result 260mm rounding up at first number of integer.

So, I made below

round(258*2,-1)/2

but, the "-1" is not working what it works like in Excel function.

Please, help me to figure it out.

[leesonghyunJNSUP]

I want to make result that the first number of integer 5 units.

[m.krom]

Please try this;

round(( ( your value ) * 5 mm ) / 5 mm)

round(( ( ( 258 mm * 2 ul ) ) * 5 mm ) / 5 mm)

Make sure all units are setup correctly.

[JelteDeJong · Accepted solution]

For rounding up to the next highest whole number use "Ceil()".

In his case you would get:

ceil(<your value/parameter> / 5 mm ) * 5 mm

[m.krom]

I know about the Ceil, Floor and Round functions. But thanks for your feedback. Greatly appriciated.

[leesonghyunJNSUP]

Thank you very much. you are the one of my savior!