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