need to make a "IF, OR" statement

[Marq]

need to make a formula that states the following:

if any one of the cells in cell range A1 thru G7 contains either the letter "L" OR the Letter "U" then cell I7 will equal the comment "No Card"....If the letter "L" or "U" are not in any of the cells then the cell I7 will show text Approved.

anyone

 

[Scott Huish]

Perhaps:

=IF(COUNTIF(A1:G7,"L")+COUNTIF(A1:G7,"U"),"No Card","Approved")

 

[Legacy 51064]

=if((countif(A1:G7,"U")+countif(A1:G7="L"))>=1,"No Card","Approved")

 

[Scott Huish]

The >=1 is not necessary because 0 will automatically equate to FALSE

 

[Marq]

works perfect..thanx!

 

[barry houdini]

Could also use

=IF(SUM(COUNTIF(A1:G7,{"L","U"})),"No Card","Approved")

 

[Marq]

thanx again gang....works fantastic!