In some programming languages you are able to express something like
A if A != null else B. This can be expressed in Calc with
IF(A; A; B).
Now suppose that
A is a long formula. Is there any trick to avoid repeating the long formula in both the 1st and 2nd arguments?