| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
| Inconsistent Macro Behavior | Excel Discussion (Misc queries) | |||
| Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
Hybrid Mode
