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