ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   wild card with if logical function (https://www.excelbanter.com/new-users-excel/91608-wild-card-if-logical-function.html)

b166er

wild card with if logical function
 

hi members,

i need help on how to use wild cards(*/?) with if logical
function is it possible to use with if logical function if yes please
just tell me how to use wild cards dont tell me about alternative
functions


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=547357


Bob Phillips

wild card with if logical function
 
Here is one way

=IF(ISNUMBER(FIND("asp",C2)),"found","not found")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"b166er" wrote in
message ...

hi members,

i need help on how to use wild cards(*/?) with if logical
function is it possible to use with if logical function if yes please
just tell me how to use wild cards dont tell me about alternative
functions


--
b166er
------------------------------------------------------------------------
b166er's Profile:

http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=547357





All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com