Iogic problems

sky · Mar 10th, 2002, 09:19 PM

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?

Mark O'Brien · Mar 10th, 2002, 09:29 PM

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

sky · Mar 10th, 2002, 09:48 PM

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 ]

Anne Troy · Mar 10th, 2002, 09:59 PM

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?

sky · Mar 11th, 2002, 06:13 PM

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

Mar 10th, 2002, 09:29 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	What's your logic formula? Chances are, that could be wrong. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 10th, 2002, 09:59 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 09:19 PM	#1
sky New Member Join Date: Mar 2002 Posts: 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?

Mar 10th, 2002, 09:48 PM	#3
sky New Member Join Date: Mar 2002 Posts: 6	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 ]

Mar 11th, 2002, 06:13 PM	#5
sky New Member Join Date: Mar 2002 Posts: 6	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..........