AnsweredAssumed Answered

Speed of Case function vs sequence of logical operators

Question asked by FrankvanderMost on Dec 13, 2016
Latest reply on Dec 13, 2016 by taylorsharpe

Let's say, I need a function that delivers 1 when a number of tests A, B, C, ... L have been passed and otherwise 0

 

Would it be faster to use a Case function like this

 

Case (

     not A ; 0 ;

     not B ; 0 ;

     ...

     not L ; 0 ;

 

     1)

 

or to use a logical formula like:  A and B and ... L ?

 

I am assuming that the Case function will stop evaluating as soon as one of the tests 'not X' have been met.

 

Is the calculation engine sophisticated enough to stop evaluating the logical formula as soon as one of the tests A to L results in 0 ?

 

Which of the two would be faster with a given set of outcomes for A to L?

Outcomes