Parameter Rounding to Multiples - similar to MROUND in Excel

[ggoodey]

I have a parameter FLANGE_WIDTH controlling the width flange...

I would like to place a hole approximately half way across the flange, rounded up to the nearest 5 mm.

So if I have a 75 mm flange, I would the hole to be 40 mm from the edge instead of 37.5.

In Excel this would be:

=MROUND((FLANGE_WIDTH/2),5)

Is there a function to accomplish this in Inventor?

I know I can link to Excel, but I would prefer not to have any external references in this instance.

Thanks in advance

Grant

[stephengibson76 · Accepted solution]

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

type this in for your hole distance, you could use the floor or ceiling function if you wanted the hole to move a certain way

[Loren_J]

Search Help for "formulas and equations." This should return the Functions topic. It lists the parameter functions in Inventor.

[ggoodey]

Brilliant!

Thank you both.

Grant