Question regarding equation output if cell value is negative
In a budget tracking sheet I created, I have a row titled "Remaining" that subtracts monthly input spending from the original "Bid" column. In the case that a value in the "Remaining" column is negative (over budget) I would like this number to be subtracted from a contingency row I have in my bid column where everything is totaled and output the result of that equation to my remaining column in in the contingency row. I have included a screenshot labeled to clarify.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!