IF function with two conditions

[nfisher1510]

I need to have a function to work as follows:

Row B3:B11 if the letter D or B are present return Good, If neither are present then return need

If I have two D's in the Cells or 2 B's in the cell I need it return Good also.
The below formula works if I only have a D in the cells, but if I take the D out and add a B it returns a need. I need it to return a Good if either letters are in there.
=IF(COUNTIF(C3:C11,"D"),"Good","Need")

 

[gaz_chops]

Try

=IF(OR(COUNTIFS(C3:C11,"D"),COUNTIFS(C3:C11,"B")),"Good","Need")

 

[nfisher1510]

Yes this worked. I think I missed the S on the COUNTIF before.
Thanks

 

[gaz_chops]

You're welcome, the S isn't needed in this case, countif is used when 1 criteria, countifs when multiple criteria, i'm just in the habit of using countifs

 

[Scott Huish]

A bit shorter:

=IF(SUM(COUNTIF(C3:C11,{"B","D"})),"Good","Need")