Dave Bruns

In this example, the goal is to extract the top-level domain (TLD) from a list of domains. A top-level domain is the last segment of text in a domain name, for example, ".com", ".net", or ".net". In the current version of Excel, the TEXTAFTER function is a simple way to solve this...Read more

The goal is to do something if a cell equals a given value. The most common way to solve this problem is with the IF function.

IF function

The IF function runs a logical test and returns one value for a TRUE result, and another value for a...Read more

At the core, this formula is composed of two sets of the COUNTIF function wrapped in the IF function. The outer IF + COUNTIF first checks to see if the value in question (B4) appears more than once in the list:...Read more

In this example, the goal is to count odd numbers in the range B5:B15, which is named data. This can be done with the SUMPRODUCT function together with the ISODD function. Instead of ISODD, the MOD function can also be used. Both approaches are explained below.

...Read more

In this example, the goal is to count the number of cells in data (B5:B15) that are not equal to "red" or "blue". This problem can be solved with the COUNTIFS function or the SUMPRODUCT function, as explained below.

Not equal to

The not equal to...Read more

Excel contains a number of rounding functions. Two of these functions, the INT function and the TRUNC function will return the integer portion of a number that contains  a decimal value.

The INT function...Read more

With TRUNC, no rounding takes place. The TRUNC function simply slices off the decimal part of the number with default settings.

TRUNC actually takes an optional second argument to specify the precision of truncation, but when you don't supply this...Read more

In the example, cell C6 contains this formula:

=MROUND(B6,5)

The value in B6 is 17 and the result is 15 since 15 is the nearest multiple of 5 to 17.

Other multiples

As you'd expect, you can use MROUND to round to other...Read more