Hi, I hope someone can help me with this.

I'm using Excel 2003 and I have the following function:

=IF(A1>=0,A1/IF(OR(B1=0,ISERROR(B1)),AVERAGE($C$1:C4),B1),-A1/
IF(OR(ISERROR(B1),B1=0),AVERAGE($C$1:C4),B1))

The important thing here is that B1 is a standard deviation, and it
may take either real values (when more than 1 value is avalaible), 0
(when no values are available) or #DIV/0 (when only 1 value is
available).

By using the evaluate function option I can see that in cases where B1
is 0 the OR function basically compares within a TRUE and a FALSE
value, giving a TRUE as the answer (what I hope for), but when it
checks a #DIV/0 value it considers ISERROR(B1) as TRUE and B1=0 as
#DIV/0, and instead of generating TRUE as the result of the OR it
generates a #DIV/0 error.

Considering that the OR function should be TRUE as lonas any of the
values is TRUE, that should not happened.  I've tried changing the
order of the arguments so that it does not need to continue checking
the other arguments as soon a TRUE is found, but Excel continue
checking the other arguments.

Thank in advance for any help you can provide me.

DF