Iogic problems

sky

New Member
Joined
Mar 9, 2002
Messages
6
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?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
 
Upvote 0
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?
 
Upvote 0
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..........
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top