AND Function
I assume that FielExists and Filesize are two UDFs? In that case, your
question is nothing to do with the evaluation of the conditions, but with
the UDFs, at least that is how I see it.
The AND will always evaluate both conditions, even if the first fails,
unnecessary but that is the way that it is, so your second UDF would need to
also check if the file exists, or maybe ditch FileExists and do it all in
Filesize, and return -1 if it doesn't exist.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Mike McLellan" wrote in message
...
The expression that I want to evaluate is along the following lines:
=IF(AND(FileExists(name),FileSize(name)25000)
If the file doesn't exist, then the second argument will fail.
I think the best answer is probably to force the FileSize function to
return
0 if the file doesn't exist
Thanks for your help
"Bob Phillips" wrote:
I don't understand, what difference does it make? As long as a False
condition evaluates to False, isn't that OK? It would make a difference
with
OR, but not AND.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Mike McLellan" wrote in
message
...
Does the AND function always evaluate all arguments or only until it
comes
across the first one that evaluates as FALSE? If the former is the
case,
is
there any way to make it work the second way without using a n ested
IF
statement?
|