In D6, the formula is:

This is an example ofnesting the OR function isnestedinside the IF function.

This result is returned directly to the IF function as thelogical_testargument.

If the result of the test is FALSE, we simply return the original price.

IF function example - increase price if color is red or green

More than one condition can be tested by nesting IF functions.

OR returns TRUEif any condition is TRUE.

If all conditions are FALSE, the OR function returns FALSE.

IF function example - increase price if color is red or green

IF function example - increase price if color is red or green

IF function example - increase price if color is red or green

IF function example - increase price if color is red or green

Excel formula: If cell equals

Excel formula: If this AND that

Excel formula: If NOT this or that

Excel formula: Only calculate if not blank

Excel IF function

Excel OR function

Article image

Article image