Your reasoning is correct. Whilst the cells A11 and B4 look empty, are you
sure that they do not contain spaces(s). Do a =LEN(A11) and =LEN(B4)
somewhere, if they are not both 0, that is the problem.
Your formula also has a problem if B4 is not 0, but a11 is, as it returns a
#DIV/0! error (dividing by 0 - A11).
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam) wrote in
message ...
Hi Yes i tested the following exactly:
=IF(AND($A$11=0,B4=0),"",(D4-$A$11)/$A$11)
But now the formula part [(D4-$A$11)/$A$11] works even if only one of the
two conditions [($A$11=0,B4=0)] is true. I think the folrmula shouldn't
work
until the both conditions after AND are true.
"Springbok" wrote:
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|
|-----------------------------|
|