I am trying to change a dimension that is in a design table with an if then statement. I've tried having the statement reside directly in that cell. I've also tried to complete the logic outside of the cell, and then reference that cell from my dimension driving cell. Is this even possible? I've been able to use the truncate and simple addition as formulas, but anything more complicated seems to get kicked out. I am able to control global variables (then in turn link the dimensions to those global variables) via these more complex functions but this seems like multiple unnecessary steps to get to my end result.
Having a vlookup table directly drive a dimension value would be helpful as well.
I'm using Excel 2007 and Solidworks 2014.
Any advice would be appreciated!