AnsweredAssumed Answered

if statements inside of an equation

Question asked by Joe Marchbanks on Dec 4, 2015
Latest reply on Dec 7, 2015 by Kevin Chandler

Like • Show 0 Likes0
Comment • 5

Hello I've been trying to use the following if statement below to locate a intermediate post member for some stair handrails and it looks correct in the equation =33in, but it comes with a syntax error, but then it shows in the sketch as 40.333 not 33in. below is a jpeg and also the if statement being used. The syntax error happens when I try to put the second if statement into the equation. I must have something out of place here, but I just don't see it. Any suggestions would be greatly appreciated.

= if ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , if ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HR-L@Sketch1" / 3 ) )

Jakob Deslippe Dec 5, 2015 7:02 AM

Correct Answer

Hi Joe,

Try this:

=iif ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , iif ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HR-L@Sketch1" / 3 ) )

you need to use "iif" when nested if statements for some reason, hopefully this works for you.

See the reply in context

No one else had this question

Outcomes

Kevin Chandler Dec 4, 2015 9:11 PM

Hello,

Since Manage Equations has such limited programming prowess, I try to break longer statements into shorter, related ones.

That said, try this:

Create two global variables:

HRCheck1 = if ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , "HR-L@Sketch1" / 3 )

HRCheck2 = if ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HRCheck1" )

Set the sketch dim to ="LRCheck2"

From "HRCheck1", for all values >= 120, the divisor is 3 and 2 for less than 120.

From "HRCheck2", when greater than 240, the divisor is 4, else the computation satisfying "HRCheck1" is used.

Cheers,

Kevin

Edit: I forgot to mention that starting with SW2015, "if" statements can use >= and <= comparisons, in case you need to land on the 120 or 240 value.

Actions

Joe Marchbanks @ Kevin Chandler on Dec 5, 2015 9:29 AM

Thanks Kevin, I was unaware of the update in SW2015. I'm sure this option will work, but right now I just checked Jackobs answer and I confirmed it worked. looks like this scenario I would have to have 2 sketch dimensions drive rather than 1 sketch dimension.

Actions

Kevin Chandler @ Joe Marchbanks on Dec 7, 2015 8:09 AM

Hello,

No problem, he did address your OP.

Actually I missed it because, as I posted, SW is so limited I was instantly focused on splitting for simplification.

Please keep my post in mind as your equations become more involved.

I find a few global variables become much easier to follow (and debug), especially since the only conditionals SW offers are "if" and "iff".

Nested if's tend to get tangled quite easily and also untangle not so easily.

Cheers,

Kevin

Actions

Jakob Deslippe Dec 5, 2015 7:02 AM

Hi Joe,

Try this:

=iif ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , iif ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HR-L@Sketch1" / 3 ) )

you need to use "iif" when nested if statements for some reason, hopefully this works for you.

Actions

Joe Marchbanks @ Jakob Deslippe on Dec 5, 2015 9:30 AM

Thanks, This worked perfectly. Since SW prompts for IF not IFF when I type if in I figured "if" would work.

Actions

5 Replies

Kevin Chandler Dec 4, 2015 9:11 PM
Mark Correct
Correct Answer
Hello,

Since Manage Equations has such limited programming prowess, I try to break longer statements into shorter, related ones.
That said, try this:

Create two global variables:
HRCheck1 = if ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , "HR-L@Sketch1" / 3 )
HRCheck2 = if ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HRCheck1" )

Set the sketch dim to ="LRCheck2"

From "HRCheck1", for all values >= 120, the divisor is 3 and 2 for less than 120.
From "HRCheck2", when greater than 240, the divisor is 4, else the computation satisfying "HRCheck1" is used.

Cheers,

Kevin

Edit: I forgot to mention that starting with SW2015, "if" statements can use >= and <= comparisons, in case you need to land on the 120 or 240 value.
Like • Show 0 Likes0
Actions
- Joe Marchbanks @ Kevin Chandler on Dec 5, 2015 9:29 AM
  Mark Correct
  Correct Answer
  Thanks Kevin, I was unaware of the update in SW2015. I'm sure this option will work, but right now I just checked Jackobs answer and I confirmed it worked. looks like this scenario I would have to have 2 sketch dimensions drive rather than 1 sketch dimension.
  Like • Show 0 Likes0
  Actions
  - Kevin Chandler @ Joe Marchbanks on Dec 7, 2015 8:09 AM
    Mark Correct
    Correct Answer
    Hello,
    
    No problem, he did address your OP.
    
    Actually I missed it because, as I posted, SW is so limited I was instantly focused on splitting for simplification.
    
    Please keep my post in mind as your equations become more involved.
    I find a few global variables become much easier to follow (and debug), especially since the only conditionals SW offers are "if" and "iff".
    Nested if's tend to get tangled quite easily and also untangle not so easily.
    
    Cheers,
    
    Kevin
    Like • Show 0 Likes0
    Actions
Jakob Deslippe Dec 5, 2015 7:02 AM
Unmark Correct
Correct Answer
Hi Joe,

Try this:
=iif ( "HR-L@Sketch1" < 120 , "HR-L@Sketch1" / 2 , iif ( "HR-L@Sketch1" > 240 , "HR-L@Sketch1" / 4 , "HR-L@Sketch1" / 3 ) )

you need to use "iif" when nested if statements for some reason, hopefully this works for you.
Like • Show 0 Likes0
Actions
- Joe Marchbanks @ Jakob Deslippe on Dec 5, 2015 9:30 AM
  Mark Correct
  Correct Answer
  Thanks, This worked perfectly. Since SW prompts for IF not IFF when I type if in I figured "if" would work.
  Like • Show 0 Likes0
  Actions

if statements inside of an equation

Outcomes

Related Content

Recommended Content