Return 0 if result of formula is lower than 0.5

H

Hendrik

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(SEARCH("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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Product sum??? summing cells if a condition is true! PLEASE HELP!! 1
OR in SUMPRODUCT formula 4
Smaller than 0 to return a 0 result 1
Sumproduct not counting if the formula result is zero 1
if statement to return a list of values where answer is true 8
Macro code to partially format font colour of result in cellcontaining a formula 3
IF Function returns result of formula 2
opinion on code / formula reiult 0

Top