IF function
Excel » Functions » Logical » IF function »
If cell equals value from list
Regular formula Formula in cell C3: =IF(COUNTIF($E$3:$E$5,B3),"Yes","No") The COUNTIF function counts how many values in E3:E5 match cell B3, it returns […]
If cell contains text from list
This article demonstrates several ways to check if a cell contains a value based on a list. The first example […]
The formula above in cell D3 performs two different logical tests, if at least one of them is TRUE one […]
The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and […]
Use IF + COUNTIF to perform numerous conditions
The COUNTIF function allows you to construct a small IF formula that carries out plenty of logical expressions. Combining the IF […]
IF with AND function – multiple conditions
The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]
Nested IF statements in a formula are multiple combined IF functions so more conditions and outcomes become possible. They all are […]
Checks if a logical expression is met. Returns a specific value if TRUE and another specific value if FALSE.