Archive

CONTAINSSTRINGEXACT

Returns TRUE or FALSE indicating whether one string contains another string.

CONTAINSSTRING

Returns TRUE or FALSE indicating whether one string contains another string.

CONCATENATEX

Concatenates the result of an expression evaluated for each row in a table.

CONCATENATE

Joins two text strings into one text string.

CODE

Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

XNPV

Returns the present value for a schedule of cash flows that is not necessarily periodic.

XIRR

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

VARX.S

Returns the variance of a sample population.

VARX.P

Returns the variance of the entire population.