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.
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.
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.
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.
As you'd expect, you can use MROUND to round to other...Read more
In the example, cell C6 contains this formula:
=ROUND(B6,-3)
The value in B6 is 1,234,567 and the result is 1,235,000.
With the ROUND function, negative numbers for the second argument round to the left of the decimal and positive...Read more
This can be an intimidating formula if you don't have a good background in math, but let's work through it step-by-step.
First, when you have a formula like this where one function (in this case ROUND) wraps around all others, it's often helpful to work from the outside in. So, at the...Read more