Results 1 to 2 of 2

Blank cell with formula NOT blank

Threaded View

  1. 05-21-2020, 10:43 PM #1
    turkiother
    turkiother is offline
    Registered User
    Join Date
    05-09-2020
    Location
    ksa
    MS-Off Ver
    13
    Posts
    4

    Blank cell with formula NOT blank

    Hi,
    Please i need assistance, See the attached file, i use a formula to extract non blank cell from a row and its work only if row cell is truly blank but in case the blank cell has formula excel consider these blank cell as not blank....

    Regards,,,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] checking for a blank cell and returning blank in another as part of a nested IF formula
    By 1learning excel1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2019, 07:05 AM
  2. [SOLVED] Need help making COUNTIFS formula display as blank if it's 'criteria cell' is blank
    By 27POP27 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2018, 07:38 AM
  3. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  4. [SOLVED] leaving blank cells blank in dragging formula, combining different formulas in one cell.
    By camadax in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-15-2014, 02:36 AM
  5. [SOLVED] When my formula encounters a blank cell it returns a 0, I need it to return a blank
    By stretch99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2014, 07:52 PM
  6. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  7. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1