Hello all, I trying to create a formula to add d5=b5+c5 but if c5 is negative, d5 will still be $7500.00. Then d6=b6+c6 but the negative from c5 has to be subtracted from c6 (if c6 is positive). Gets real confusing when 2 months in a row show negatives. My goal is d- column will never be lower than b-column but will not increase if their is no positive commission on profit (column c) I've attached an example sheet to help explain what I'm after. Thanks in advance!
Bookmarks