AnsweredAssumed Answered

BOM Equation with IF Statement

Question asked by Trevor Hall on Oct 15, 2015

I have a BOM with QTY of whole numbers, and extruded lengths in "in" (inches).  I want the equation to say IF THE QUANTITY IS IN INCHES, I WANT TO SEE IT IN FEET INSTEAD.

 

The equation to convert is okay with {1}'QTY.'/12" FT", but it messes up the whole numbers.  Hence the need for an IF statement.

Outcomes