+ Reply to Thread
Results 1 to 6 of 6

keep cell blank if IF statement is False

  1. #1
    ruthslaughter
    Guest

    keep cell blank if IF statement is False

    I'm trying to keep a cell blank for the False component of an IF statement.
    If I leave it blank it comes back with False in the cell. I don't want
    anything in the False section of the IF statement. How do I do that?

  2. #2
    Max
    Guest

    Re: keep cell blank if IF statement is False

    Put: "" as the value_if_false in the IF
    Example: =IF(expression, value_if_true , "")
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --
    "ruthslaughter" <ruthslaughter@discussions.microsoft.com> wrote in message
    news:87B01F3E-5849-47AB-A1AF-A6DAC778880B@microsoft.com...
    > I'm trying to keep a cell blank for the False component of an IF

    statement.
    > If I leave it blank it comes back with False in the cell. I don't want
    > anything in the False section of the IF statement. How do I do that?




  3. #3
    noyb
    Guest

    Re: keep cell blank if IF statement is False

    If the cell evaluates to "" and then shows blank, but, another cell
    references the blank cell that second cell returns a #VALUE. Its OK if
    the cell evaluates to a number but not "". Is there a way around this?
    Thanks

    Max wrote:
    > Put: "" as the value_if_false in the IF
    > Example: =IF(expression, value_if_true , "")
    > --
    > Rgds
    > Max
    > xl 97
    > ---
    > Singapore, GMT+8
    > xdemechanik
    > http://savefile.com/projects/236895
    > --
    > "ruthslaughter" <ruthslaughter@discussions.microsoft.com> wrote in message
    > news:87B01F3E-5849-47AB-A1AF-A6DAC778880B@microsoft.com...
    >
    >>I'm trying to keep a cell blank for the False component of an IF

    >
    > statement.
    >
    >>If I leave it blank it comes back with False in the cell. I don't want
    >>anything in the False section of the IF statement. How do I do that?

    >
    >
    >


  4. #4
    Peo Sjoblom
    Guest

    Re: keep cell blank if IF statement is False

    Post the formula that returns the value error, a value error occurs when you
    calculate with text like "" so you can replace it with 0 instead if you add
    it or you can use functions that ignores text like SUM or SUMIF

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "noyb" <noyb@anoynomous.ca> wrote in message
    news:ueQrfxP8FHA.1484@tk2msftngp13.phx.gbl...
    > If the cell evaluates to "" and then shows blank, but, another cell
    > references the blank cell that second cell returns a #VALUE. Its OK if the
    > cell evaluates to a number but not "". Is there a way around this?
    > Thanks
    >
    > Max wrote:
    >> Put: "" as the value_if_false in the IF
    >> Example: =IF(expression, value_if_true , "")
    >> --
    >> Rgds
    >> Max
    >> xl 97
    >> ---
    >> Singapore, GMT+8
    >> xdemechanik
    >> http://savefile.com/projects/236895
    >> --
    >> "ruthslaughter" <ruthslaughter@discussions.microsoft.com> wrote in
    >> message
    >> news:87B01F3E-5849-47AB-A1AF-A6DAC778880B@microsoft.com...
    >>
    >>>I'm trying to keep a cell blank for the False component of an IF

    >>
    >> statement.
    >>
    >>>If I leave it blank it comes back with False in the cell. I don't want
    >>>anything in the False section of the IF statement. How do I do that?

    >>
    >>


  5. #5
    Max
    Guest

    Re: keep cell blank if IF statement is False

    As Peo mentioned (Thanks, Peo !),
    we could use: =IF(expression, value_if_true , 0) instead
    to avoid downstream calc issues.

    And to achieve a clean look, if desired, we could switch off
    the display of "extraneous" zeros in the sheet via:
    Tools > Options > View tab > Uncheck "Zero values" > OK
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



  6. #6
    noyb
    Guest

    Re: keep cell blank if IF statement is False

    Thanks, I did not realize that =sum(a1,b1) when a1 = "" would not return
    #VALUE.


    Peo Sjoblom wrote:
    > Post the formula that returns the value error, a value error occurs when
    > you calculate with text like "" so you can replace it with 0 instead if
    > you add it or you can use functions that ignores text like SUM or SUMIF
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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