AnsweredAssumed Answered

Nested IF statements in a BOM

Question asked by Tom Cote on Mar 8, 2012
Latest reply on Jan 23, 2018 by Thijs Vernooij

Like • Show 0 Likes0
Comment • 8

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

No one else has this question

Outcomes

8 Replies

Scott McFadden Mar 8, 2012 7:20 AM
Mark Correct
Correct Answer
Tom,
Take a look at this thread and see if it helps you.

https://forum.solidworks.com/message/190994#190994
Like • Show 0 Likes0
Actions
James Bailey Mar 8, 2012 8:21 AM
Mark Correct
Correct Answer
I haven't read into this deeply or anything, but just looking at your IF statement, there's a simple syntax error:

IF(Condition, True Value, False Value {Else [begin next if condition or end if statement]}

Your false value is "" where it should be where your next IF statement starts. So maybe something like this:

IF(`Largeur`= "SO"; `Largeur`; IF(`Longueur`="SO"; `Longueur`; ""))
Like • Show 0 Likes0
Actions
- Tom Cote @ James Bailey on Mar 8, 2012 9:06 AM
  Mark Correct
  Correct Answer
  Hi James,
  
  Thanks, that is really close; but if the custom property has any value (like a #) it still leaves the cell in the BOM blank. I think now it is in the False Value part so I tried adding ="":
  
  IF(`Largeur`= "SO"; `Largeur`=""; IF(`Longueur`="SO"; `Longueur`=""; ""))
  
  But that did not work. Any thoughts?
  
  Thanks again,
  Tom
  Like • Show 0 Likes0
  Actions
  - Tom Cote @ Tom Cote on Mar 8, 2012 10:31 AM
    Mark Correct
    Correct Answer
    All right, got it closer to figured out. Below is my current IF statement line. The problem is I need them to be an AND statement not one or the other. I went with the >0 (greater than zero) because the value can either be SO or it can be a number. It work for either in this case.
    
    IF(`Largeur`> 0; `Largeur`; IF(`Longueur`>0; `Longueur`; ""))
    
    Any help would be appreciated.
    Thanks, Tom
    Like • Show 0 Likes0
    Actions
    - James Bailey @ Tom Cote on Mar 8, 2012 10:43 AM
      Mark Correct
      Correct Answer
      Ok, so would you like the condition to be met if both Largeur AND Longueur are >0?
      
      IF(AND(`Largeur`,`Longueur`)> 0 ; `Largeur` "" `Longueur` ; "")
      [need to check concatenation syntax on this - I'm more used to Java]
      
      I suppose I'd like to know the context of this code so I can figure out what you're intent is. Is your output to a single cell?
      Like • Show 0 Likes0
      Actions
      - Tom Cote @ James Bailey on Mar 8, 2012 11:21 AM
        Mark Correct
        Correct Answer
        Hi James,
        
        Yes I'm trying to have it that if one is SO and the other is a # just the number will show up in the cell.
        It's kind of weird but that is the this company does their custom properties.
        
        Thanks again for your help.
        Like • Show 0 Likes0
        Actions
Daen Hendrickson Mar 8, 2012 2:03 PM
Mark Correct
Correct Answer
James,

I was able to get a version of your formula to work.

Here are the specifics:
I have three parts. Each part had custom properties of Largeur and Longueur added to them.
Part 1: Largeur = SO, Longueur = SO
Part 2: Largeur = SO, Longueur = 10
Part 3: Largeur = 15, Longueur = 20

These parts were placed in an assembly and a drawing with a BOM table added. I added a column to the BOM table and added an equation to the column.

The equation is:

IF(`Longueur`<>"SO";`Longueur`;IF(`Largeur`<>"SO";`Largeur`;""))

If I recall from Josh Brady's presentation, the "=" sign in your previous equation tells SW to ignore the VBA and head off in an unwanted direction. Also the formula would not evaluate with the nested IF statement in the "if true" section of the parent IF statement. It needed to be moved to the "else" section.

I am not sure what you want your BOM column to show if both properties are numbers. With this formula, if both are SO, you get a blank;if Longueur is NOT SO, you get Longueur regardless of Largeur; and if Longueur is SO and Largeur is NOT SO you get Largeur.

Hope this helps.

Daen
Like • Show 1 Like1
Actions
Thijs Vernooij Jan 23, 2018 4:52 AM
Mark Correct
Correct Answer
Please try the formula in the BOM like this:

IF(`CD_Material`="";`Supplier`;IF(`CD_Material`="Material <not specified>";`Supplier`;`Supplier`))

This wil use the Supplier value when the Material is Empty "" or "Material <not specified>"
Like • Show 1 Like1
Actions

Nested IF statements in a BOM

Outcomes

Related Content

Recommended Content