Forum Discussion

scolgate's avatar
scolgate
Copper Contributor
Mar 21, 2020

IF Function Referencing Multiple & Return Blank

Hi,   So I'm starting my exploration into Excel and formulas so my question is basic but so far I haven't cracked it so I'm asking for a little guidance on Nested IF ðŸ™‚   In one cell I have the p...
excel
Formulas and Functions
PChoate's avatar
PChoate
Copper Contributor
Mar 22, 2020

scolgate 

 

Yes, the innermost IF needs a value to return:

=IF(D5="Example1",5,IF(D5="Example2",10,IF(D5="Example3",15,IF(D5="Example4",20,""))))

Resources