On Tue, 27 Mar 2007 17:59:02 -0700, Hendrik wrote:

Hi Ron,

Thanks for your help. I've worked it out now.

I'm using this formula:

=IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2) )*(C3:R3=0.25)),SUMPRODUCT(ISERR(SEARCH("evt",$C$2 :$R$2))*(ISERR(SEARCH("ABS",$C$2:$R$2)))*C3:R3),0)

And can expand it perfectly with more arguments. Maybe you can help me one
step further. When the result of the above formule is lower than value 0.50,
I want it to display 0.00

Any suggestions on how to accomplish this?


The solution that occurs to me now (after a fine meal and a significant amount
of adult beverages :-)) is:

=IF(formula<0.5,0,formula)

where "formula" is the above long formula.


--ron