Results 1 to 21 of 21

formula to leave the cell blank

Threaded View

  1. 09-19-2016, 12:53 PM #10
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: formula to leave the cell blank

    Without using VBA, you cannot have a formula in a cell return an empty cell. Either there is a formula in a cell, a value in a cell, or nothing.
    Last edited by 63falcondude; 09-19-2016 at 01:26 PM.
    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. Leave cell blank if referenced cell and/or formula is blank or incomplete
    By alonsogar in forum Excel General
    Replies: 1
    Last Post: 06-29-2016, 03:44 AM
  2. Formula needed to leave cell blank
    By jennijohnstone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2015, 07:41 AM
  3. Leave cell result blank if blank cell is in formula
    By Grind in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 09-28-2013, 06:15 AM
  4. If Then formula. If false, I would like to leave the cell blank.
    By joaquinwalking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2013, 01:56 PM
  5. Formula to leave a cell blank
    By dandavis1 in forum Excel General
    Replies: 6
    Last Post: 08-25-2009, 05:54 AM
  6. Question: How do I leave a cell blank if formula value is #N/A
    By Chobi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2008, 04:08 PM
  7. [SOLVED] Formula <0 leave cell blank
    By Whit in forum Excel General
    Replies: 3
    Last Post: 08-12-2006, 09:50 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