12 When to use which function
| Situation/Circumstance/Problem | Desired Results | Function(s) |
| One question | TRUE or FALSE | no function needed — just ask your question Example: =A6 >=B7 |
| More than one question | TRUE or FALSE | Use and AND or an OR function |
| Example: =OR(A6>=B7,C9<E18) | ||
| One question | 2 results other than TRUE or FALSE | Use IF function |
| Example: =IF(A6>=B7, C9+E18,0) | ||
| More than one question | 2 results other than TRUE or FALSE | Use IF and AND or OR functions |
| Example: =IF(OR(A6>=B7,C9<E18),C9+E18,0) | ||
| More than one question | More than 2 results | Use nested IF functions |
| Note: You’ll use one LESS IF than your number of possible results | ||
| Example: =IF(A6>=B7, C9+E18,IF(D12<C8,0,F14)) | ||
| or | ||
| Use HLOOKUP or VLOOKUP function* | ||
| *Variations on HLOOKUP and VLOOKUP: | H- or VLOOKUP | |
| No Calculations | ||
| Combine IF with H- of VLOOKUP functions | ||
| Multiple H-or VLOPPUPS in one formula |