|
0 instead of false
Hi all,
I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))*1
-- Gary's Student "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
On Sun, 10 Dec 2006 04:55:01 -0800, Jaleel
wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel Try: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) --ron |
0 instead of false
Thank you very much. It worked fine. Can you explain what is the *1 function?
Regards, Jaleel "Gary''s Student" wrote: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))*1 -- Gary's Student "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Try this:
=IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) Or this: =IF(AO7,IF(AP7,Z7,0),0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Enclose everything in the N worksheet function:
=N(IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))) "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Thanks Jim. It also worked. What was the shortcoming of my formula?
Regards, Jaleel "Jim Cone" wrote: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Thanks Ron. What was the shortcoming of my formula?
Regards, Jaleel "Ron Rosenfeld" wrote: On Sun, 10 Dec 2006 04:55:01 -0800, Jaleel wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel Try: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) --ron |
0 instead of false
You'd given the outcome for AO7=TRUE, but not for the alternative condition.
Another way would be =IF(AND(AO7=TRUE,AP7=TRUE),Z7,0) -- David Biddulph "Jaleel" wrote in message ... Thanks Jim. It also worked. What was the shortcoming of my formula? Regards, Jaleel "Jim Cone" wrote: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
=IF( AND( AO7, AP7 ), Z7, 0 )
or if Z7 is always a number =AO7 * AP7 * Z7 -- Regards, Luc. "Festina Lente" "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
It is just a way to convert TRUE/FALSE to 1/0
-- Gary''s Student "Jaleel" wrote: Thank you very much. It worked fine. Can you explain what is the *1 function? Regards, Jaleel "Gary''s Student" wrote: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0))*1 -- Gary's Student "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Thanks David for your explanation.
Regards, Jaleel "David Biddulph" wrote: You'd given the outcome for AO7=TRUE, but not for the alternative condition. Another way would be =IF(AND(AO7=TRUE,AP7=TRUE),Z7,0) -- David Biddulph "Jaleel" wrote in message ... Thanks Jim. It also worked. What was the shortcoming of my formula? Regards, Jaleel "Jim Cone" wrote: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Thanks a lot for all of you who replied with their wonderful formulas. I was
wondered at the shortest formulas of Papa and Rag. Cheers! Jaleel "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
your formula can be written as
N(AO7*AP7*Z7) "Jaleel" wrote: Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
What about using the "--" (I forget the $0.50 word/phrase for it) which
Converts TRUE/FALSE to 1/0,,?? =--IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) "Jim Cone" wrote in message : =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel |
0 instead of false
Surely it was the missing else condition that caused Flase in the first
place Steve On Sun, 10 Dec 2006 18:27:00 -0000, JMay wrote: What about using the "--" (I forget the $0.50 word/phrase for it) which Converts TRUE/FALSE to 1/0,,?? =--IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) "Jim Cone" wrote in message : =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0),0) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Jaleel" wrote in message ... Hi all, I put a formula in AR7 like this: =IF(AO7=TRUE,IF(AP7=TRUE,Z7,0)) It is showing FALSE. Both the cells AO7 AND AP7 are false as they are some arguments. How can I get "0" instead of 'FALSE"? Thanks & Regards, Jaleel -- Steve (3) |
0 instead of false
On Sun, 10 Dec 2006 05:25:01 -0800, Jaleel
wrote: Thanks Ron. What was the shortcoming of my formula? Regards, Jaleel =IF(AO7=TRUE, IF(AP7=TRUE,Z7,0),???????) Note that if your first condition is FALSE, you have not defined what to do (that's where I have the ?'s). In that circumstance, the function will return a FALSE. --ron |
| All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com