Hi all,
I am trying to figure out whether if it's possible to assign 2 formula to 1 parameter. What I' trying to achieve is to have an option to turn off all the "Rivet hole" if I tick "Rivetcentre" but also keep the formula "Panel Length > 3850" at the same time. Is there a way to do that?
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
Gelöst von EATREVITPOOPCAD. Gehe zur Lösung
I am not sure what you are trying to achieve exactly but my guess is you need to use an IF statement with some ANDs and/or ORs
Syntax for Conditional Statements
A conditional statement uses this structure: IF (<condition>, <result-if-true>, <result-if-false>)
This means that the values entered for the parameter depend on whether the condition is satisfied (true) or not satisfied (false). If the condition is true, the software returns the true value. If the condition is false, it returns the false value.
Conditional statements can contain numeric values, numeric parameter names, and Yes/No parameters. You can use the following comparisons in a condition: <, >, =. You can also use Boolean operators with a conditional statement: AND, OR, NOT. Currently, <= and >= are not implemented. To express such a comparison, you can use a logical NOT. For example, a<=b can be entered as NOT(a>b).
The following are sample formulas that use conditional statements.
Simple IF: =IF (Length < 3000mm, 200mm, 300mm)
IF with a text parameter: =IF (Length > 35', “String1”, “String2”)
IF with logical AND: =IF ( AND (x = 1 , y = 2), 8 , 3 )
IF with logical OR: =IF ( OR ( A = 1 , B = 3 ) , 8 , 3 )
Embedded IF statements: =IF ( Length < 35' , 2' 6" , IF ( Length < 45' , 3' , IF ( Length < 55' , 5' , 8' ) ) )
IF with Yes/No condition: =Length > 40 (Note that both the condition and the results are implied.)
Still not enough information to figure out your true intent (for me at least lol)
do you want the Rivethole7VS parameter to be checked if Rivetcentre parameter is checked AND Panel Length parameter is greater than 3850 ? if so here is the formula
IF ( AND (Rivetcentre = true, Panel Length > 3850), On, Off)
I would just double check the On / Off, it may be called true or false, or yes and no.... not sure to be honest but you get the idea
Ok so I tested to see if its yes / no or true / false or On / Off and etc... and apparently it's neither which is silly to me. I am sorry I didn't expect it.
Here is what the actual formula would be
IF ( AND (Rivetcentre, Panel Length > 3850), 1=1, 1=2)
If you read about if statements first part is a condition, the second part is if it's true, and the third part if it's false.
now 1=1 is true so if Rivetcentre is checked and Panel Length is over 3850 the statement will say 1 = 1 which is a true statement so the result is checkbox
and 1=2 is not a true statement so the checkbox will not be checked
Sorry for confusion
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.