Data validation rules are triggered when a user adds or changes a cell value.
The AND function takes multiple arguments (logical expressions) and returns TRUE only when all arguments return TRUE. In this case, we need...

The goal of this example is to verify input before calculating a result. The key point to understand is that any valid formula can be substituted. The SUM function is used only as an example. The logic can also be...

In the example shown, row 5 is a header row and which contains a series of valid dates, formatted with the custom number format "d". With a static date in D5, you can use =D5+7 (copied across) to populate the calendar...

In the image shown, the current date is August 19, 2019.
Excel dates are serial numbers, so you can manipulate them with simple math operations. The TODAY function always returns the current date. Inside the AND...

Data validation rules are triggered when a user adds or changes a cell value.
The AND function takes multiple arguments (logicals) and returns TRUE only when all arguments return TRUE. The DATE function creates a...

This formula relies on a technique called "nested IFs" to handle a series of options and results. With nested IFs, one IF function is nested inside another, a process that is explained in some detail here.
The formula...

When you use a formula to apply conditional formatting, the formula is evaluated for each cell in the range, relative to the active cell in the selection at the time the rule is created. So, in this case, if you apply...

In the example shown, we simply want to "mark" or "flag" rows where the color is "red" AND size is either "small" or "medium". To return TRUE when items are red and small, we can use a logical statement constructed...

The value in G5 is hard-coded. The formula picks up the value in G5, then subtracts the value (if any) in E6 and adds the value (if any) in F6. When the credit or debit values are empty, they behave like zero and have...

The challenge with lookup formulas that retrieve more than one match is managing duplicates (i.e. multiple matches). Lookup formulas like VLOOKUP and INDEX + MATCH can easily find the first match, but it's much harder...

In this formula, the logical test is this bit:
AND(OR(B5="red",B5="green"),C5>10)
Note that the "parent" function is AND The OR function is logical1 inside the AND function while C5>10 is...

The purpose of this formula is to demonstrate how other formulas and functions can be nested inside the IF function.
The IF function takes three arguments like this:
=IF(logical_test, value_if_true, value_if_false...

Data validation rules are triggered when a user adds or changes a cell value.
The UPPER function changes text values to uppercase, and the EXACT function performs a case-sensitive comparison.
The AND function takes...

In the example shown, we want to test if all values in each row are equal. To do this, we use an expression that compares the value in the first column (B5) to the rest of the columns (C5:F5):
B5=C5:F5
Because we...

The trick with this approach is the calendar header (row 4), which is just a series of valid dates, formatted with the custom number format "d". With a static date in D4, you can use =D4+1 to populate the calendar....