Multiple cells for IF function

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

I'm trying to figure a way to determine if a word appears in a range of cells
to return a certain value. For instance. If the word "Holiday" appears in
blocks A1 through A200, then in cell B2 it would return a value of "taken" if
it doesn't appear in that range then return a value of "Need to take" how
can this be done. I have been able to use the IF function to return the
desired outcome for only one of the cells, but when I attemp to use a range
of cells it will not work. Please help.
 
Use COUNTIF()

If holiday is a cell value
=IF(COUNTIF(A1:A100,"Holiday"),"Taken","Need to take")

If holiday is within the cell
=IF(COUNTIF(A1:A100,"*Holiday*"),"Taken","Need to take")


If this post helps click Yes
 
Thank you so much. Is there a way I can change the cell color for the
different results?
 
Back
Top