UA-32896419-1

Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account


(View All Videos) Toggle Members Videos


- - - - -

Conditional formula

Conditional formula

This article follow a question ask by Steve about formatting a conditional formula.
Step 1 - I need to understand the conditions

You want 182.7 → 50 - 300 │ 202.7 → 300 - 500

What happens when length is below 50?
What happens when length is higher than 500?


Step 2 - Lets write the conditions ( here i will make assumptions to answer the two questions i have)

100*(Length<50) │ 182.7*(length=>50) │ 201.7*(Length=>300) │ 210*(Length=>500)
............................182.7*(length<300)....201.7*(Length<500)


Step 3 - Add the necessary logic argument

100*(Length<50) OR 182.7*(length=>50) AND 182.7*(length<300) OR 201.7*(Length=>300) AND 201.7*(Length<500) OR 210*(Length=>500)


Step 4 - Wrap everything into a single formula
Compare to the example of the tutorial that was written under ST2 ( I think) i enclose the AND between bracket. Maybe something has change in the internal code. I probably should add a note to my blog article

=ABS((100*(Length<50))OR(182.7*((Length=>50)AND(Length<300)))OR(201.7*((Length=>300)AND(Length<500)))OR(210*(Length=>500)))

For reason i can't explain for this long conditional formula, the OR need to be enter as a mathematical sing instead of the logic argument.

=ABS((100*(Length<50))+(182.7*((Length=>50)AND(Length<300)))+(201.7*((Length=>300)AND(Length<500)))+(210*(Length=>500)))

Attach is the ST5 file with the formula

View attachment: OR_AND ST5.zip
  • Terry likes this


4 Comments

Cool!
Photo
Community Administrator
Mar 09 2013 05:42 AM
    • Terry likes this

Nice article. Conditional formulas are very useful. Just a note, "-" is OR and "+" is AND. Also, if you are working on long formulas it is helpful to work in something like notepad and copy and paste into the variables table. This way you will not loose the whole formula if you make a syntax error.

Photo
Community Administrator
Mar 25 2013 01:49 PM

Thanks Terry

 

This is why in the original article I layout a method to create long formula :-)

 

See table at the bottom of the article

 

http://soliddna.word...tional-formula/


Recent Comments