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

Tom,

A closer look at your formula shall tell you the reason.

Let me take a case where D3 =5000. The intended value is 1 but your formula shall return 2. This is because the first if shall see that D3 >1600 and hence shall return 2.

You can start comparison with the highest value first and then move down like: -

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

You just need to write the formula correctly and then things shall be all correct.

Hope it helps!!!

Rajat Jain