Dave Bruns

In this example, the goal is to calculate a sum of the values in a range that are generated with a formula. In other words, we want to sum values in a range while ignoring the values that have been entered manually. In the context of this example, the hardcoded values in C5:C12 represent ...Read more

The goal is to display a blank cell based on a specific condition. In the worksheet shown, we want to return the value from column C, but only when the value in column B is "A". If the value in column B is anything else, we want to display nothing. The easiest way to solve this problem is with...Read more

This formula works for times entered in a particular format as shown below:

00h01m13s
00h01m08s
08h02m59s

Note the text string is always 9 characters long, and each component is 2 digits.

The core of this formula is the TIME...Read more

The key to this formula is the array or TRUE and FALSE values constructed with this expression:

LEFT(code,1)<>"N"

Here, each value in the named range "code" is evaluated with the logical test "...Read more

For this example, we want to calculate the interest paid during each year in a 5-year loan of $30,000 with an interest rate of 5%. To do this, we set up CUMIPMT like this:

• rate - The interest rate per period. We divide 5% by 12 because 5% represents annual
...Read more