Results 1 to 3 of 3

Thread: How do you create a formula whose output is a BLANK cell?

  1. #1
    Seeker gfr92y's Avatar
    Join Date
    Feb 2015
    Location
    Richmond, VA
    Posts
    5
    Articles
    0
    Excel Version
    2013

    How do you create a formula whose output is a BLANK cell?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How do you create a formula whose output is a BLANK cell?


    Remember a cell whose result is "" is not BLANK.


    For example, =ISBLANK(IF(1=1,"","")) results in False.

  2. #2
    Conjurer Logit's Avatar
    Join Date
    Nov 2016
    Posts
    312
    Articles
    0
    Excel Version
    2007
    Here is a resource with an EXTENSIVE discussion of the goal :

    https://stackoverflow.com/questions/...rmula-in-excel

  3. #3
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    198
    Articles
    0
    Excel Version
    2010
    Cross-posted here: https://www.ozgrid.com/forum/index.p...-a-blank-cell/

    Please take a minute to read the forum rules and follow them in future. Thank you.
    This website wants to know your momentum - | Deny | | Allow |

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •