AnsweredAssumed Answered

If formula in assembly design table

Question asked by Tom Durrance on Mar 26, 2012
Latest reply on Mar 29, 2012 by Mauricio Martinez-Saez

Hi

 

Hope someone can help me.

I have set up an assembly which has a plate and another part which is stubs.

I want the stubs to change pattern qty as the length of the plate changes.

I have set up an design table and this seems to work ok until I update it.

The excel sheet has now been updated which should show more stubs in certain configurations, but when I go back to the assembly the qty which is shown in the excel design table does not show on the assembly.

All configurations show 2 stubs, yet in the excel sheet some are supposed to be 4.

The formula I have in the Excel design sheet is

=IF(D3>1600,"2",IF(D3>1000,"4",IF(D3>1799,"6",IF(D3>2000,"1"))))

 

Thanks in advance

Outcomes