Iogic problems
Find bottlenecks in your Excel workbooks
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,581
    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..........

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
  •  

 

 
DMCA.com