# Iogic problems

This is a discussion on Iogic problems within the Excel Questions forums, part of the Question Forums category; I have a logic formula which is false but excel is reading as true and following the true result and ...

1. 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. What's your logic formula? Chances are, that could be wrong.

3. 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. Generally, I'm thinking you've got a couple problems here.

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

=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?

5. 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..........

#### Posting Permissions

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