How to display sum of two cells but only if another cell has a number greater than 0.1

[Tristram_ZX81]

I want cell C4 to display A4:B4, but only if the value of A4 or B4 is equal to or greater than 0.2. But I also need C4 to equal 0.1 if either A4 or B4 has a value of 0.1. (Due to the way the formula is designed in A4 and B4, they will never display 0.1 and any other number). I thought the below formula might work, but it doesn't. Any ideas?

=IF(ISNUMBER(SEARCH(0.1,A4)),0.1,IF(ISNUMBER(SEARCH(0.1,B4)),0.1,IF(ISNUMBER(SEARCH(">=0.2",A4)),A4:B4,IF(ISNUMBER(SEARCH(">=0.2",B4)),A4:B4))))

 

[Eric W]

Try:

=IF(OR(A4=0.1,B4=0.1),0.1,IF(OR(A4>=0.2,B4>=0.2),A4+B4,""))

 

[Tristram_ZX81]

Try:

=IF(OR(A4=0.1,B4=0.1),0.1,IF(OR(A4>=0.2,B4>=0.2),A4+B4,""))

Perfect, thanks Eric!

 

[Eric W]

Happy to help! ?

 

[Tristram_ZX81]

That formula worked for C4, bit when I tried to drag the formula down to the rows below it's returning an #VALUE! on any row where the number in column A or B isn't 0.1 I need it to give me the sum of A:B if either cell is 0.2 or higher. Any ideas?

 

[Eric W]

Try changing it to:

=IF(OR(A4=0.1,B4=0.1),0.1,IF(OR(A4>=0.2,B4>=0.2),SUM(A4:B4),""))

Rows 10-13 still puzzle me though. I don't see why those are giving #VALUE errors. What is the formula in A10 and B10?

 

[Tristram_ZX81]

It works. You are my spirit animal, Eric. Thanks again.

In the original doc after your first response, A10 was

=IF(OR(A10=0.1,B10=0.1),0.1,IF(OR(A10>=0.2,B10>=0.2),A10+B10,""))