The DELTA function tests two numeric values for equality. When values are equal, DELTA returns 1. When values are different, DELTA returns zero. As a result, DELTA can be used to easily count pairs of equal numbers.
For example:
=DELTA(5,4) //...Read moreThe Excel T function converts numbers, dates, and the logical values TRUE and FALSE into empty strings. Text values and errors are not converted and pass through unaffected. You can use the T function to remove values that are not text.
The T...Read more
In this example, the goal is to calculate a conditional sum with the SUMPRODUCT function to match the criteria shown in G5:G7. One way to do this is to use the IF function directly inside of SUMPRODUCT. Another more common alternative is to use Boolean logic to apply criteria. Both approaches...Read more
In this example, the goal is to count values in three non-contiguous ranges with criteria. To be included in the count, values must be greater than 50. The COUNTIF counts the number of cells in a range that meet the given criteria. However, COUNTIF does not perform counts across different...Read more
The MDETERM function returns the matrix determinant of a given array, which must be a square matrix containing numbers only, and no empty values. In mathematics, the matrix determinant is a scalar value (single value) that is a function of the entries in a square matrix. The determinant...Read more
The MINVERSE function returns the inverse matrix of a given array. The product of a matrix and its inverse is the identity matrix, a n × n square matrix with ones on the main diagonal and zeros in every other position.
The MINVERSE function takes just one argument,...Read more
The MUNIT function returns a unit matrix for a given dimension, n, with a size of n x n. The unit matrix is also called the identity matrix. The MUNIT function takes just one argument, dimension, which should be a positive...Read more
This formula calculates total working hours between two dates and times, that occur between a "lower" and "upper" time. In the example shown, the lower time is 9:00 AM and the upper time is 5:00 PM. These appear in the formula as the named ranges "lower" and...Read more