Hi,
Not sure if the problem lies in the format of the numbers (i.e. text)? Have
you tested it?
Cheers,
Jon

"Ibrahim Awwad" wrote:

Dear All,

I'm trying to use theIF function as following =IF(And
(y=0,z=0),x,z), but the -AND- logical test isn't working. The formula part of
the true value is implemented even if the y=0 or z=0 not both of them.

Is there any help.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|-----------------------------|
|Islam is peace not Terror|
|-----------------------------|