-
Description Check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.…
-
Description Return one value if a condition is true and another value if it’s false. NOTE Syntax SAMPLE data EXAMPLE…
-
Description Checks whether the cell is an error and returns TRUE or FALSE depending on the result. NOTE Syntax SAMPLE…
-
Description Returns the average of the set numbers. NOTE Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Checks whether the cell is blank and returns TRUE or FALSE depending on the result. NOTE Syntax SAMPLE data…
-
Description Checks whether the specified value is a text and returns TRUE or FALSE depending on the result. NOTE Syntax…
-
Description Checks whether the specified value is a number and returns TRUE or FALSE depending on the result. NOTE Syntax…
-
Description Returns the smallest number in a set of numbers. NOTE Syntax SAMPLE data EXAMPLE 1 EXAMPLE 2 RELATED
-
Description Rotate data from rows to columns or vice versa. NOTE Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Returns the largest number in a set of numbers. NOTE Syntax SAMPLE data EXAMPLE 1 EXAMPLE 2 RELATED
-
Description Returns the matrix product of two arrays. NOTE Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Returns the reference specified by a text string. NOTE Syntax SAMPLE data EXAMPLE 1 EXAMPLE 2 RELATED
-
Description Converts a text string that represents a number to a number. NOTE Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Returns a reference to a range that is a specified number of rows and columns from reference cell[s]. NOTE…
-
Description Excludes all empty rows and/or columns from the outer edges of a range or array. NOTE Syntax SAMPLE data…
Join our newsletter to stay up to date
Click the button below to sign up for our advanced platform. Get started now and see the benefits for yourself.
Email address