Forum Discussion

emilymarty1's avatar
emilymarty1
Copper Contributor
Jul 05, 2017
Solved

IF Function

I am trying to use an IF function that looks at words rather than numbers. I would like the function to look at the data range B4:B20 and if they all have Yes typed in I would like the function to di...
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jul 05, 2017

    Hi

     

    =IF(COUNTIF(B4:B20,"Yes")=ROWS(B4:B20),"Certified","Training needed")

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 05, 2017

Hi

 

=IF(COUNTIF(B4:B20,"Yes")=ROWS(B4:B20),"Certified","Training needed")

 

Resources