XNPV
The XNPV function returns the net present value of scheduled cash flows that are not necessarily periodic.
XIRR
The XIRR function returns the internal rate of return for scheduled cash flows that are not necessarily periodic.
UNICHAR
The UNICHAR function returns the Unicode character corresponding to the indicated "code point".
MAXA
The MAXA function returns the largest value in a column considering numbers, dates, and Booleans.
CHISQ.DIST
The CHISQ.DIST function returns the chi-square distribution for a given value.
VAR
The VAR function stores the result of an expression as a variable, being possible to pass it as an argument to other expressions that define a measure.
BETA.INV
The BETA.INV function returns the inverse of the cumulative beta probability density function for a given probability.
PATHLENGTH
The PATHLENGTH function returns the number of parents of the corresponding item, including itself.
sum
The sum function sums the start value and the values contained in the iterator included as the first argument, returning the total. By default, start takes the value 0.
PATHITEMREVERSE
The PATHITEMREVERSE function returns the item that occupies the indicated position in a string resulting from executing the PATH function, being the positions counted from right to left.
