AnsweredAssumed Answered

Greater than less than equation?

Question asked by Chad Hawkenson on Feb 13, 2013
Latest reply on Feb 18, 2013 by Chad Hawkenson

Like • Show 0 Likes0
Comment • 5

Help please!

I need help with an equation.

I would like to would like to control the suppression of a feature based on a global variable. I have this so far but can not get it to work properly:

NAME VALUE/EQUATION

CUT-EXTRUDE4 =IF("DOORWIDTH">24.0625<29,"UNSUPPRESSED","SUPPRESSED")

CUT-EXTRUDE5 =IF("DOORWIDTH">29.0625<36,"UNSUPPRESSED","SUPPRESSED")

CUT-EXTRUDE6 =IF("DOORWIDTH">36.0625<48,"UNSUPPRESSED","SUPPRESSED")

As you can see as my door width variable changes I just wan't a certain feature suppressed or not. If my door is 32" I want CUT-EXTRUDE5 unsuppresed. I just dont think I have the equation written properly. Can someone help please with a greater than less than equation.

Chad Hawkenson Feb 18, 2013 10:25 AM

Correct Answer

Thank you everyone for your help. I actually got it to work using the equation in the attached screen shot.

Thanks again.

See the reply in context

No one else had this question

Outcomes

Jeremiah Feist Feb 13, 2013 5:49 PM

one way is to use a nested if:

=if("doorwidth">=29, "suppressed",if("doorwidth"<=24.0625, "supressed","unsupressed"))

Actions

Chad Hawkenson @ Jeremiah Feist on Feb 14, 2013 8:46 AM

Thanks for the reply Jeremy but unfortunately I get the "the syntax of this equation is incorrect" I entered it exactly how you have it. What am I missing please. I understand your logic but cant get S.W. to understand.

Actions

Jeremiah Feist @ Chad Hawkenson on Feb 15, 2013 4:04 PM

I think I had the '<' and '=' reversed, but even switching them around doesn't work for me either. neither did removing the '='s - I am stumped.

Actions

Josh Brady @ Jeremiah Feist on Feb 15, 2013 8:59 PM

I think the new "if" syntax doesn't work when nested. It's all part of the "improved" equation interface. I hate it. It's great for people who don't have a clue what they are doing... Holds your hand real nice for really basic stuff. However, for power users it just gets in the way with bogus errors and warnings.

For years and years, the way to get an IF statement was actually to use the VBA "iif" function. That's two "i"s. Other than that, there's no difference between the old "iif" and the new "if", except that the new "if" doesn't work for nesting. Same syntax and everything, just add another "i".

I think the new equation interface will actually complain at you if you try to use iif. However, it will still work. You may have to create your equation once with some syntax that SW thinks is valid. Then, after you exit the equation dialog and open it again you can edit the equation to use the functioning "iif". Once you save that equation and close the dialog, the next time you open the equation tool it will have screwed up your nice iif equation. Fear not. Just don't touch it and it should be fine. If you do have to edit it, you'll have to remove the extra quote marks that SW puts in.

If you actually know what you're doing and don't need the hand-holding, go to www.angelsix.com and download the equation editor macro from Luke Malpass. It functions pretty much like the old "edit all" button. No "live" syntax checking, and no immediate view of the result, but much better if you know what you're doing better than the people who wrote the new interface.

Actions

Chad Hawkenson Feb 18, 2013 10:25 AM

Thank you everyone for your help. I actually got it to work using the equation in the attached screen shot.

Thanks again.

Attachments

ifthanpic.docx510.9 KB

Actions

5 Replies

Jeremiah Feist Feb 13, 2013 5:49 PM
Mark Correct
Correct Answer
one way is to use a nested if:

=if("doorwidth">=29, "suppressed",if("doorwidth"<=24.0625, "supressed","unsupressed"))
Like • Show 0 Likes0
Actions
- Chad Hawkenson @ Jeremiah Feist on Feb 14, 2013 8:46 AM
  Mark Correct
  Correct Answer
  Thanks for the reply Jeremy but unfortunately I get the "the syntax of this equation is incorrect" I entered it exactly how you have it. What am I missing please. I understand your logic but cant get S.W. to understand.
  Like • Show 0 Likes0
  Actions
  - Jeremiah Feist @ Chad Hawkenson on Feb 15, 2013 4:04 PM
    Mark Correct
    Correct Answer
    I think I had the '<' and '=' reversed, but even switching them around doesn't work for me either. neither did removing the '='s - I am stumped.
    Like • Show 0 Likes0
    Actions
    - Josh Brady @ Jeremiah Feist on Feb 15, 2013 8:59 PM
      Mark Correct
      Correct Answer
      I think the new "if" syntax doesn't work when nested. It's all part of the "improved" equation interface. I hate it. It's great for people who don't have a clue what they are doing... Holds your hand real nice for really basic stuff. However, for power users it just gets in the way with bogus errors and warnings.
      
      For years and years, the way to get an IF statement was actually to use the VBA "iif" function. That's two "i"s. Other than that, there's no difference between the old "iif" and the new "if", except that the new "if" doesn't work for nesting. Same syntax and everything, just add another "i".
      
      I think the new equation interface will actually complain at you if you try to use iif. However, it will still work. You may have to create your equation once with some syntax that SW thinks is valid. Then, after you exit the equation dialog and open it again you can edit the equation to use the functioning "iif". Once you save that equation and close the dialog, the next time you open the equation tool it will have screwed up your nice iif equation. Fear not. Just don't touch it and it should be fine. If you do have to edit it, you'll have to remove the extra quote marks that SW puts in.
      
      If you actually know what you're doing and don't need the hand-holding, go to www.angelsix.com and download the equation editor macro from Luke Malpass. It functions pretty much like the old "edit all" button. No "live" syntax checking, and no immediate view of the result, but much better if you know what you're doing better than the people who wrote the new interface.
      Like • Show 0 Likes0
      Actions
Chad Hawkenson Feb 18, 2013 10:25 AM
Unmark Correct
Correct Answer
Thank you everyone for your help. I actually got it to work using the equation in the attached screen shot.
Thanks again.
Attachments
- ifthanpic.docx510.9 KB
Like • Show 0 Likes0
Actions

Greater than less than equation?

Outcomes

Attachments

Related Content

Recommended Content