+ Reply to Thread
Results 1 to 3 of 3

TRUE condition???

  1. #1
    Forum Contributor
    Join Date
    10-04-2004
    MS-Off Ver
    2013
    Posts
    148

    TRUE condition???

    Hi

    I have an IF formula in one cell which returns "" (blank) if the condition is true. But if I use, in another cell:

    =A1>0

    where A1 is my first cell, theoretically blank, it returns TRUE...

    Any explanations???

    Thank You!

  2. #2
    Guest

    Re: TRUE condition???

    Hi

    Maybe your first IF formula has a true option:
    =IF(A2=10,"","False")

    Andy.

    "pmguerra" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi
    >
    > I have an IF formula in one cell which returns "" (blank) if the
    > condition is true. But if I use, in another cell:
    >
    > =A1>0
    >
    > where A1 is my first cell, theoretically blank, it returns TRUE...
    >
    > Any explanations???
    >
    > Thank You!
    >
    >
    > --
    > pmguerra
    > ------------------------------------------------------------------------
    > pmguerra's Profile:
    > http://www.excelforum.com/member.php...o&userid=14986
    > View this thread: http://www.excelforum.com/showthread...hreadid=548586
    >




  3. #3
    David Biddulph
    Guest

    Re: TRUE condition???

    "pmguerra" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi
    >
    > I have an IF formula in one cell which returns "" (blank) if the
    > condition is true. But if I use, in another cell:
    >
    > =A1>0
    >
    > where A1 is my first cell, theoretically blank, it returns TRUE...
    >
    > Any explanations???


    Blank is different from empty.
    You may want something like
    =AND(A1>0,A1<>"")
    --
    David Biddulph



+ 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