I'm trying to create a formula that adds my second and third column if the fourth column says "LOST" , I want that same formula to subtract the second column from the first column if the fourth column says "KEPT".
-My column titles are:
Column1: total budget
Column2: money allocated
Column3: tentative remaining
Column4: account status
Column5: amount remaining
I've been fooling around with different formulas for a while and I can't get anything to work. any suggestions?
