You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion.

To help set the order for functions in a multiple function formula, you use parentheses within parentheses. When the formula is run, Calc does the innermost function first, then works outwards. For ...

Multiple Polylogarithms: Functions defined through iterated integrals or series that extend the polylogarithm, closely related to and instrumental in the study of multiple zeta functions.