Dave Bruns

The cube root of a number can be calculated manually with the exponentiation operator (^) or with the POWER function.

Manually with ^

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

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

In this example, the goal is to count numbers in the range B5:B15 (named data) that begin with the numbers shown in column D. You would think this would be a good problem to solve with the COUNTIF function but for reasons explained below,...Read more

In this example if a task is marked "Done", then it is considered complete. The goal is to calculate the percent complete for the project by showing the ratio of complete tasks to total tasks, expressed as a percentage. The formula in F6 is:

=COUNTA(C5:C11)/...Read more