iLogic: round up to nearest 5 or 10

[Anonymous]

I have calculated minimum required clearance gap based on user input in iLogic.

I would like to write a script that rounds up the numbers, so the last digit is always 0 or 5.

Example:

1 becomes 5

4 becomes 5

5 stays 5

5.5 becomes 10

9 becomes 10

1427 becomes 1430

Any suggestions on how to accomplish this?

[torbjorn_heglum1 · Accepted solution]

In VBA I would do approximately as this to round x up to the nearest 5.

Ceil(x/5)*5

Will also work as a standard Inventor formula.

Torbjørn

[Anonymous]

Thanks, this works perfectly!

[Kassenbouw]

How does this work with Round?

Round(x/5)*5 i guess? This didn't work for me, I hope you know how this works with the Round function.

Cheers