Results 1 to 3 of 3

If cell contains partial text and 2nd reference is blank formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-19-2016
    Location
    Alaska
    MS-Off Ver
    MS 2010, 2013, 2016
    Posts
    272

    If cell contains partial text and 2nd reference is blank formula

    Hello everyone

    The formula below looks to see if the cell contains the word "Test" and also checks to see if another cell is not blank. If this conditions are true, then it should return a blank value, else it should return "Test Found", I just can't get the formula to return that. Not sure where I'm wrong.

    IF(ISNUMBER(SEARCH(and("Test",E2,F2<>""),"","Test Found")))
    Last edited by AccountingJ; 10-14-2020 at 06:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-20-2020, 07:17 PM
  2. [SOLVED] Reference cell formula returning 0 when BLANK, need BLANK to show
    By williamc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2016, 04:23 PM
  3. If formula to return blank if reference cell blank
    By dhooper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 08:56 PM
  4. Replies: 11
    Last Post: 02-08-2012, 12:36 PM
  5. Excel 2007 : Partial text of reference cell
    By donkeylarry in forum Excel General
    Replies: 3
    Last Post: 02-07-2012, 06:48 PM
  6. Replies: 5
    Last Post: 02-18-2007, 06:30 PM
  7. formula to extract partial content (text) of cell
    By milano in forum Excel General
    Replies: 3
    Last Post: 11-09-2005, 01:00 PM

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