ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 795
- Office Version
- 365
- 2019
- Platform
- Windows
Class | Amount | Yes (Formula Below) |
1 | -100 | |
2 | 200 |
<tbody>
</tbody>
Hello,
I am having considerable trouble trying to get a combo of all three to function as intended. A very simplistic explanation. If 1 class is greater than 0 and 1 class is less than 0 then take the class with the greater ABS.
My Formula:=IF(OR(AND(B2<0,B3>0,B2>0,B3<0),AND(ABS(B2)<ABS(B3))),"Yes","No")
Formula works, but breaks down if cell B2 is positive 100 it also gives me a value of yes. Anyone able to help