ExcelBanter - If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If statement (https://www.excelbanter.com/excel-programming/308086-if-statement.html)

dave

If statement

How do you use a wildcard in an if statment.

Frank Kabel

If statement

Hi
could you be more precise?
Do you mean something like
=IF(COUNTIF(A1,"*text*"),"'text' is within cell A1","")

--
Regards
Frank Kabel
Frankfurt, Germany

Dave wrote:
How do you use a wildcard in an if statment.

dan

If statement

Looking for something like :

if (a1="BL(whatever)", "Bug Light", "other")

info in cell A1 could be BH1 BJ3 BL1 BL2 BL3 VW4

-----Original Message-----
Hi
could you be more precise?
Do you mean something like
=IF(COUNTIF(A1,"*text*"),"'text' is within cell A1","")

--
Regards
Frank Kabel
Frankfurt, Germany

Dave wrote:
How do you use a wildcard in an if statment.
.

Frank Kabel

If statement

Hi
=IF(COUNTIF(A1,"BL*"),"Bug Lighter","other")

--
Regards
Frank Kabel
Frankfurt, Germany

Dan wrote:
Looking for something like :

if (a1="BL(whatever)", "Bug Light", "other")

info in cell A1 could be BH1 BJ3 BL1 BL2 BL3 VW4

-----Original Message-----
Hi
could you be more precise?
Do you mean something like
=IF(COUNTIF(A1,"*text*"),"'text' is within cell A1","")

--
Regards
Frank Kabel
Frankfurt, Germany

Dave wrote:
How do you use a wildcard in an if statment.
.

All times are GMT +1. The time now is 06:08 PM.