Return 0 if result of formula is lower than 0.5
 

Try this amendment:
=IF(SUMPRODUCT(ISNUMBER(SEARCH("break",$C$2:$R$2)) *(C3:R3=0.25)),IF(SUMPRODUCT(ISERR(SEARCH("evt",$C $2:$R$2))*(ISERR(SEARCH("ABS",$C$2:$R$2)))*(ISERR( SEARCH("lunch",$C$2:$R$2)))*C3:R3)<=0.5,0,SUMPRODU CT(ISERR(SEARCH("evt",$C$2:$R$2))*(ISERR(SEARCH("A BS",$C$2:$R$2)))*(ISERR(SEARCH("lunch",$C$2:$R$2)) )*C3:R3)),0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hendrik" wrote:
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)))*(ISERR(SEA RCH("lunch",$C$2:$R$2)))*C3:R3),0)

When the result is equal to or lower then 0.50 ,I want it to display 0.00 in
the cell as result.

Any suggestions greatly appriciated!