Forum Discussion

lilian51129's avatar
lilian51129
Copper Contributor
Oct 20, 2022
Solved

If a range contains text then return a single value

Hi there,   I have the below column in a tab called "Product Ideas":   New ingredients or comps oat syrup almonds stuff       I want to create a formula in a new cell where...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 20, 2022

    lilian51129 You could try something like this instead:

     

    =IF(COUNTA(G4:G12),"yes","no")

     

     

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 20, 2022

lilian51129 You could try something like this instead:

 

=IF(COUNTA(G4:G12),"yes","no")

 

 

 

lilian51129's avatar
lilian51129
Copper Contributor
Oct 20, 2022
worked like a charm, thank you!

Resources