Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
b166er
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wild Card Search roy.okinawa Excel Worksheet Functions 4 January 30th 06 10:42 PM
Logical Function Question jgp_2 Excel Worksheet Functions 2 September 28th 05 07:24 PM
Logical AND function John Pinback Excel Worksheet Functions 5 May 3rd 05 09:52 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
using logical functions as criteria with the SUMIF function pfdubz Excel Worksheet Functions 6 December 1st 04 07:40 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"