Tristram_ZX81
New Member
- Joined
- Jun 22, 2021
- Messages
- 45
- Office Version
- 365
- Platform
- Windows
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))))
=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))))