+ Reply to Thread
Results 1 to 2 of 2

ISBlank formula

  1. #1
    Registered User
    Join Date
    06-06-2008
    Posts
    2

    ISBlank formula

    Hi there
    This should be a very simple formula, but I'm having a hard time figuring it out.

    =IF(ISBLANK(B1),"xx","")

    B1 is blank but has a formula in it. See attachment

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: ISBlank formula

    Maybe this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by AlKey; 12-04-2017 at 06:27 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Excel 2007 : Help with a IF/IsBlank Formula
    By Chips Reynolds in forum Excel General
    Replies: 4
    Last Post: 04-06-2012, 09: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