Formats a number and converts it to text
Read MoreEvaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
Read MoreReturns the sum of the products of corresponding array components
Read MoreAdds the cells in a range that meet multiple criteria
Read MoreAdds its arguments
Read MoreSubstitutes new text for old text in a text string
Read MoreReturns the k-th smallest value in a data set
Read MoreConverts a serial number to a second
Read MoreFinds one text value within another (not case-sensitive)
Read MoreReturns the number of rows in a reference
Read MoreReturns the row number of a reference
Read MoreReturns the rightmost characters from a text value
Read MoreReplaces characters within text
Read MoreReturns the quartile of a data set
Read MoreReturns the quartile of the data set, based on percentile values from 0..1, exclusive
Read MoreCapitalizes the first letter in each word of a text value
Read MoreReturns TRUE if any argument is TRUE
Read MoreReturns a reference offset from a given reference
Read MoreReturns the serial number of the current date and time
Read MoreReverses the logic of its argument
Read More