Test a value in a cell

[macca99]

Hi.

I would like to test a cell value in a range of cells in a specific row and if not found enter text in an adjacent cell.

eg if a cell in the range B2:H2 does bot contain a letter S then in cell A2 show "Does not contain S" Then continue to the next row and do the same test.

TIA

 

[Richard Schollar]

Is that formula or VBA? Formula wise could be in A1:

=IF(COUNTIF(B2:H2,"*S*"),"Value if contains S","Does Not Contain S")

altho this won't be case sensitive (wasnt sure if this was important)

 

[macca99]

Thanks Richard.

Case is not important but I trialled your formula and it gave all "Does Not contain S" even though some did have an S.

Macca

 

[macca99]

Richard you put me on the right track and this is formula worked.

=IF(COUNTIFS(B2:H2,"S")>0,"Has an S", "Does not have an S")

Thanks

 

[Scott Huish]

Richard's formula should work, but if you mean if it contained an S, it would only contain an S and nothing else, which is indicated by the formula you gave, then you should only need:

=IF(COUNTIF(B2:H2,"S"),"Has an S","Does not have an S")

 

[macca99]

Just tried it again and indeed it did work this time (not sure what i did)

Thanks