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