If the coloris"Red" OR “Green”, we want to display nothing.
IF function logic
TheIF functionis commonly used for simple tests.
Otherwise, return “Fail”.
If the coloris"Red" or “Green” we don’t want to do anything.
TheNOT functionsimply reverses this result.
Since we want to flag items that pass the test, we provide “x” forvalue_if_true.
you’re able to extend the OR function to check additional conditions as needed.
Also, notice that we need to provide an empty string ("") for the false result.
If the color is Red or Green, you want to leave the price alone.
Otherwise, return the original price.
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.
When given TRUE, NOT returns FALSE.
When given FALSE, NOT returns TRUE.
Use the NOT function to reverse a logical value.
Related videos
The IF function
If this OR that
