+ Reply to Thread
Results 1 to 3 of 3

ISBLANK..Need help with simple formula

  1. #1
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    ISBLANK..Need help with simple formula

    =IF(ISNUMBER(MATCH(G1,Events!A:A,0))=TRUE,"E","NE")

    the above formula works perfectly fine, but I need to show
    the values "E" or "NE" only if cell F2 has text

    I have tried =ISTEXT(F2),(ISNUMBER(MATCH(G1,Events!A:A,0))=TRUE,"E","NE"), "")
    but doesn't work, help help fix the formula.

    Thank you,

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,810

    Re: ISBLANK..Need help with simple formula

    Try it like this:

    =IF(F2="","",IF(ISNUMBER(MATCH(G1,Events!A:A,0)),"E","NE"))

    Hope this helps.

    Pete

  3. #3
    Forum Contributor mikehk's Avatar
    Join Date
    09-05-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    483

    Re: ISBLANK..Need help with simple formula

    Thannnnnkkkkkk yooooooouuuuuuuu so much!

+ 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. Using IF formula with ISBLANK
    By banker123 in forum Excel General
    Replies: 4
    Last Post: 04-09-2014, 11:48 AM
  2. [SOLVED] IF formula not working =IF(NOT(ISBLANK(M3)),"",IF(ISBLANK(L3),"",TODAY()-L3))
    By amthyst826 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2014, 02:37 PM
  3. [SOLVED] need help with isblank formula
    By Halmsteen in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-06-2014, 11:15 AM
  4. ISBLANK formula
    By johnny_p in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 11:44 AM
  5. [SOLVED] Simple IF(ISBLANK Will not work
    By ryanch69 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2012, 04:22 AM
  6. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  7. Using IsBlank In Formula
    By scotfitz in forum Excel General
    Replies: 2
    Last Post: 09-07-2008, 05:55 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