Ok, no fun no more...
Trying to get end result based on criteria:
IF A2 is 200 + IF B2="Deposit" + IF C2="Reconciled" then D2 show A2 (which is 200) IF B2 and C2 are is blank, show "-"
IF A2 is 200 + IF B2="Withdrawal" + IF C2="Reconciled" then D2 show A2 in negative value (200) IF B2 and C2 are blank, show "-"
Tried all, AND, OR, IFS... nothing works!
What's a formula for this, please? Before going nuts here...
Bookmarks