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
|