Avoid repeating value in IF arguments

[mmoya]

Hi

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?

[mikekaganski]

Does Calc have a function similar to LET()?

Microsoft Excel has a =LET() function, which from my understanding allows one to assign names to variables. One use case is avoiding lengthy repetition within a formula. Does LibreOffice Calc have a similar function?

How to use CURRENT() multiple times in CALC

I have cells with formulas and want to add styles to the cells depending on the outcome (X) of the formula. The condition for the formatting depends on comparison of X with values of other cells. Therefore I need to use X more than once to determine the formatting. Example (with values instead of formulas and cell references and Red, Green being styles): =2+STYLE(IF(CURRENT()>1;“Green”;“Red”)) works =2+STYLE(IF(AND(CURRENT()>1;CURRENT()<3);“Green”;“Red”)) does not work =A2+$B2 +STYLE(IF(A…

The normal spreadsheet practice is to calculate A in a dedicated cell (column).

[keme1]

If you are always checking for zero, it is pretty straightforward. Use the CURRENT() function in a trailing construct like this:

=A+IF(CURRENT()=0;B;0)

EDIT: I see @mikekaganski beat me to it. The Q&As he referenced gives good background detail.