I'd like to create a create nested If-Then statements inside a BOM but cannot get through the first one. Basically what I would like is that if Largeur and Longueur are both equal to SO then I want the cell to be blank. I know how to do this type of equation in Excel but cannot get it to work inside OF SW BOM's. I have tried this in several different "tweaks" to the equation but no luck

IF(`Largeur`= "SO"; `Largeur`; ""; IF(`Longueur`="SO";`Longueur`; ""))

Any help would be greatly appreciated.

Thanks

Tom

Tom,

Take a look at this thread and see if it helps you.

https://forum.solidworks.com/message/190994#190994