 1.  ## Confirmation nested parameter

Hi guys,

How stupid is this formula?

So I'm meaning:

If the diameter is less than 700, then the distance = x - 70
If the diameter is between 700-1600, then the distance = x-40
If the diameter is more than 1600, then the distance = x  Reply With Quote

2.  Btw it says "comma not expected".  Reply With Quote

3. 1  You did not finish your formula string the first time around. It's missing the end "THEN" value and missing an if statement.

You can end the formula at :  Reply With Quote

4. 1  A formula debugger would be a great add!
Haven't debugged your whole equation, but you could simplify it.
You don't need the
and(Diameter >700,
or the
if(Diameter>1600
Formulas are parsed from left to right, so you've already gotten past the Diameter > 700 by your first test and the > 1600 by the second  Reply With Quote

5. 2   Originally Posted by Infinite ...
So I'm meaning:
(...)
If the diameter is between 700-1600, then the distance = x-40
(...)

every time you need it, it would be better to create a parameter such as "x", and make it equal to (Ext radius + Radius) / 2 ; so you just type x instead of that formula again. That would make the long formula easier to read and to debug.

2) Notice that your formula won't do what you expect when Diameter is 700 or 1600 exactly, because you are excluding those values by doing this:

and(Diameter >700, Diameter<1600)

If the intention is "between 700 and 1600", shouldn't 700 and 1600 be included in that range?

if that's the case, a better solution would be:
and(not(Diameter < 700 mm), not(Diameter > 1600 mm))
which means "at least 700 and no more than 1600"

3) Shouldn't Diameter, Radius, and Ext Radius be related to each other by formula? It seems that Diameter can be changed independently without changing Radius, and vice versa, and it seems that nothing prevents the Exterior Radius to be smaller than the Interior Radius.  Reply With Quote

6. 1   Originally Posted by Andrew K You did not finish your formula string the first time around. It's missing the end "THEN" value and missing an if statement.

You can end the formula at :

So true. Stupid I haven't seen it yet. Thanks Andrew. Originally Posted by DaveP A formula debugger would be a great add!
Haven't debugged your whole equation, but you could simplify it.
You don't need the
and(Diameter >700,
or the
if(Diameter>1600
Formulas are parsed from left to right, so you've already gotten past the Diameter > 700 by your first test and the > 1600 by the second
A debugger? That would be great! Your advice works well, never knew that. Thanks Dave! Originally Posted by Alfredo Medina every time you need it, it would be better to create a parameter such as "x", and make it equal to (Ext radius + Radius) / 2 ; so you just type x instead of that formula again. That would make the long formula easier to read and to debug.

2) Notice that your formula won't do what you expect when Diameter is 700 or 1600 exactly, because you are excluding those values by doing this:

and(Diameter >700, Diameter<1600)

If the intention is "between 700 and 1600", shouldn't 700 and 1600 be included in that range?

if that's the case, a better solution would be:
and(not(Diameter < 700 mm), not(Diameter > 1600 mm))
which means "at least 700 and no more than 1600"

3) Shouldn't Diameter, Radius, and Ext Radius be related to each other by formula? It seems that Diameter can be changed independently without changing Radius, and vice versa, and it seems that nothing prevents the Exterior Radius to be smaller than the Interior Radius.

1) True! I need to learn to combine parameters.
2) Need to try that, but it sounds very reasonable.
3+4) These parameters are dependent on each other, so you can change them independently, but the one is coming with the other one. Thickness is an easy solution for that. It's just a bit hard to think in radius-style when you always work with horizontal and vertical lines.
The snaps to reference lines are very complicated too (for me as an ameteur ofc ).

Thanks for the tips!  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•