cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Similar output as like Excel in all respective creo relation functions.

0 Kudos

Similar output as like Excel in all respective creo relation functions.

Ceil-Floor Functions in Excel Vs Creo Relations

There is totally different outputs when you use ceil & Floor Functions in Excel Vs Creo Relations.

Find attached excel file for details.

 

I think all the respective functions in Creo Relations should give similar output as excel. 

This will be very helpful to all creo user newcomers.

Generally from childhood we learn M.S. Excel first & then Creo.

So, I think if we have same output as like Excel in Creo as well, this will build more confidence in Creo Users while writing the Creo Pro program & relations.

1 Comment
Emerald I

Their definitions are completely different.  The second argument in Excel is "The multiple to use when rounding".  The second argument in Creo is "number of decimal places".

 

Since changing the definition of the function would alter relations in existing models (destroy forward compatibility), the chance of this happing is probably close to zero.