Effective app formula

[Austin]

If I have a formula with IF(Lookup(A)-Lookup(B)=10, “This is fine”, Lookup(A)-Lookup(B))
Is appsheet keeping these Lookup values from the condition for the else statement or does this statement consist of 4 lookup actions for every row regardless of A-B=10?

[Steve]

I believe the else expression is evaluated separately; the computed values from the if expression are not reused.