gtd526
Active Member
 Joined
 Jul 30, 2013
 Messages
 434
 Office Version

 2019
 Platform

 Windows
Hello,
Im trying to get rid of the False statement from the formula. I think its because of the EXACT statement, if they are great, if not, FALSE? One of the nested IFs has to be true.
Can use 1 Exact up front instead of for every IF?
The Nested IF's are due to (+) and () numbers.
thanks.
Im trying to get rid of the False statement from the formula. I think its because of the EXACT statement, if they are great, if not, FALSE? One of the nested IFs has to be true.
Can use 1 Exact up front instead of for every IF?
The Nested IF's are due to (+) and () numbers.
thanks.
Cell Formulas  

Range  Formula  
V5:V6  V5  =IF(EXACT(A5,AA5),IF(AND(B5>0,O5>0),O5B5,IF(EXACT(A5,AA5),IF(AND(B5<0,O5<0),ABS(O5)ABS(B5),IF(EXACT(A5,AA5),IF(AND(B5<0,O5>0),O5+ABS(B5),IF(EXACT(A5,AA5),IF(AND(B5>0,O5<0),ABS(O5)+B5,"")))))))) 