This formula is a classic example of a nested IF formula that tests threshold values in ascending order. To match the schedule shown in G5:G11, the formula first checks the late by time in D5 to see if it's less than 5 minutes. If so, zero points are assigned:
...Read more
By definition, the nth root of a number can be calculated by raising that number to the power of 1/n. Exponents are entered using the exponentiation operator (^), with a number on the left and power on the right. So, in this example we get the numbers from...Read more
The cube root of a number can be calculated manually with the exponentiation operator (^) or with the POWER function.
The cube root of a number can be calculated manually by raising a...Read more
The SQRT function is fully automatic and will return the square root of any positive number. For example, to get the square root of 25, you can use:
=SQRT(25) // returns 5
To get the square root of 16...Read more
The POWER function returns a number raised to a given power. POWER is an alternative to the exponent operator (^) in a math equation.
The POWER function takes two arguments: number and power. Number should be a numeric...Read more
In this example, the goal is to sum numeric values by month while ignoring the year that contains the date. The solution below is based on the SUMPRODUCT function, the MONTH function, and Boolean algebra. For convenience, amount...Read more
Working from the inside out, we use MATCH to locate the relative position of the last entry in column C:
MATCH(9.99E+307,C5:C100)
Basically, we are giving MATCH a "big number" it will never find in approximate match mode. In this mode,...Read more
This formula uses 4 named ranges, defined as follows:
width=K6
height=K7
widths=B6:B11
heights=C5:H5
Conditional formatting is evaluated relative to every cell it is applied to, starting with the active cell in the selection, which is cell...Read more