If cell begins with x, y, or z |
SUM COUNTIF |
If cell contains |
IF |
If cell equals |
IF |
If cell is blank |
ISBLANK IF |
If cell is greater than |
IF |
If cell is not blank |
ISBLANK IF NOT |
If cell is this OR that |
IF OR |
If cell is x or y and z |
AND IF OR |
If else |
IF |
If NOT this or that |
IF NOT OR |
If this AND that |
AND IF |
Nested IF function example |
IF |