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

Riny_van_Eekelen Just a question on the formula you suggested.

 

I have the below column

 

 Idea 1
Product Name0
Case Size0
Pilot Trials Required0
New comps?=IF(COUNTA(G4:G12),"yes","no")

Is there any function I can add in front of the one you suggested so the no doesn't appear when the product name is 0??

Resources