All functions / Logical
LET
Names intermediate results so a formula is easier to read.
Syntax
=LET(name, value, calculation1, [calculation2], …)
Arguments
name: A name for the value.value: The value to name.calculation: More name/value pairs, then the final calculation.
Example
=LET(rate, 0.2, B2*rate) → B2 × 20%