+ Reply to Thread
Results 1 to 6 of 6

Wildcards with IF Function?

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    MS-Off Ver
    365 version 2402
    Posts
    75

    Wildcards with IF Function?

    Can someone tell me if you are able to use wilecards with the IF Function. I am trying to see if a call contains a period. If so make the new cell true or false.

    Thanks,

    Stephen

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Does this help

    =ISNUMBER(SEARCH(".",A1))
    Returns True if A1 has a .

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699
    Another way would be

    =COUNTIF(A1,"*.*")=1

  4. #4
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    MS-Off Ver
    365 version 2402
    Posts
    75
    My end goal is to have the cell display the word "link" if the other cell does not contain a period and the word page if it does contain a period.

    With the suggestions you gave I can get to the final goal with an additional step but is there a way to combine them?

    Thanks again.

  5. #5
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Wildcards with IF Function?

    With A1 containing the cell with, or without, a period
    try this:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  6. #6
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    MS-Off Ver
    365 version 2402
    Posts
    75
    Fabuloso. It is awesome. Thank You.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 error when adding custom help file to user defined function
    By sabotuer99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2009, 01:10 AM
  2. How to display help text in the Insert function wizard (Excel)
    By sudhakard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2009, 11:01 AM
  3. Excel Function Output not updating
    By aj_uk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2008, 04:37 AM
  4. Link together different cells in specific order?
    By Sandman4432 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-03-2008, 05:01 AM
  5. Analysis Toolpak Function XIRR and VBA - XL 2007
    By rvExcelNewTip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2007, 04:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1