Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Iogic problems

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a logic formula which is false but excel is reading as true and following the true result and not the false result. What do I do?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's your logic formula? Chances are, that could be wrong.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Mark,

    But the same logic worked for other cells in the same row except for two cells, but here it is =IF(D14>=O18;SUM(D14-O18);"0").

    D14=0 from another logic formula and o18 is 50 yet I get -50 as the answer and not "0"

    Why Mark? Why?

    [ This Message was edited by: sky on 2002-03-10 20:54 ]

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Generally, I'm thinking you've got a couple problems here.

    =IF(D14>=O18;SUM(D14-O18);"0")

    Should read:

    =IF(D14>=O18;D14-O18;0)

    When you put quotes, Excel thinks you want text. So if you're using this IF on another cell that you're already using a bad IF statement on, it won't work right. Both text and formulas are seen as greater than zero (0) by Excel.

    Does that help?

    ~Anne Troy

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you Dream Boat!!!!!

    As you can see it is the first time I am using this logic commands in excel and tried to crash course the tutorial alone.

    Thank you very much and if I do have any more problems please don't forget the name

    Sky..........

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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