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)