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
not A ; 0 ;
not B ; 0 ;
not L ; 0 ;
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?