Hello everyone, I am trying to create an assembly which is driven by one mate and that mate determines the size of the components. (See attachment)
So I have 2 posts which are symmetric to the Right plane and then there is a mate called "Distance Between Posts" which is a distance mate and that determines the distance between the posts
Now the idea is, when the distance between the posts increases so does the size of the post size.
I am not the greatest at equations but in Excel I came up with an equation which gives the desired result (See Post Size Formula.xlsx)
Excel Formula:
=IF(B2<=3000,80,IF(B2<=5000,100,IF(B2<=7000,120,IF(B2<=8000,150,IF(B2<=10000,180,200)))))
Now when I try to use this formula in SolidWorks, replacing B2 with "Distance Between Post" I get a Syntax error. I think the error is with the <= part of the equation but I have been playing around with it and no luck.
I did make a simplified equation which was
= if ( "Distance Between Posts" = < 2000 , 80 , 100 )
which did change the post size to 100 but then when I changed the distance mate to 1500 the post size did not reduce back down to 80 even after rebuild.
Came to a point where I am out of ideas on how to resolve this issue so that's why I'm here, is there anyone who could assist me? Hopefully I have given enough detail
Kind Regards
Aaron,
Try to use the IIF function. Yes there are two I’s.
I attached my example of your case in weldment part. You can find my syntax in Equation Manager.
You can drive PostSize by PostDist value in Equations Manager or in Sketch1 dimension.