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