Hi,

Take a look at the SUMPRODUCT function. Barring the interpretation of your
variables (e.g. "a", "b", "c", etc.) this sounds like it may help.

HTH

--
Regards,
Zack Barresse, aka firefytr


"ddepasquale" wrote in message
...
My if statement is as follows:

=if(and(a0,c0),((a*b)+(c*d))/e,(if(a=o,c*d/e,(if(c=0,a*b/e,"")))))

It works fine for all of the conditions except for the case where none of
the parameters are true. I want it to return a blank space, instead it is
returning "value". I have tried substituting the blank space with a
number
or word and it still returns "value". Can anyone see the error.

Thank you