If I have an expressions like
OR(expression1, expression2, expression3)
Will all expressions be evaluated or will the evaluation stop as soon as expression is true?
If the latter is the case, I would get a faster app by putting the simplest or the most likely true expression first. (and the opposite for and AND() test)
An example of this would be the formula for a security filter where certain users can see all rows in a table but others can only see rows that they are somehow authorised to see. You would put the test to see if the user is an admin first as this would be true for all rows if you are the admin.