SI function in BOM

Out of category
1

Hi all

Anyone know the syntax to use to realize a double condition in an if in BOM tables?

Let me explain, in my nomenclature I would like to show the part number of the parts to be machined if they are for type: parts and if they have no symmetry (checkbox).

This works: IF('Type'="PLAN";'SW-BOM Part Number'; " ")

but I can't add a & 'SYM'=""

 

Anyone have an idea please?

 

2

Not possible in this form, you have to nest the yew in the 1st yew to get there if I'm not mistaken.

Example with an "OR" If the type property = "PI" is displayed the filename, otherwise if the type property = "AS" is displayed, the filename is displayed.

IF('Type'="PI";'Nom_Fichier'; IF('type'="AS";'Nom_Fichier';'internal code'))

For the "AND" I would say the same thing except that your 2nd IF is in the if true value (to be tested):

SI(condition_test; valeur_si_condition_test_vraie; valeur_si_condition_test_fausse)

Edit: lien vers quelques exemples:

https://www.eng-tips.com/viewthread.cfm?qid=172352

3 Likes