Skip to main content
May 3, 2018 9:29 AM UTC
Archived

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

Related products:Creo Parametric

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.

2 replies

May 4, 2018 2:03 PM UTC

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.

olivierlp
Community Manager
Jul 5, 2022 12:41 PM UTC
Status changed to: Archived

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.

Olivier