Also, are y and z named ranges or are you really using cell references?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Springbok" wrote in message
...
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|
|-----------------------------|