Need help with IF formula to add and subtract

[DavidAdamB]

Hello everyone,

I am modifying a costing sheet for my construction company, and there is a section where I summarize what is remaining in the contingency. So I need a formula that says - IF the cell in question is greater than zero (extra money), than add it to the contingency total, IF the cell in question is less than zero (losing money) than subtract it from the contingency total.

I can't seem to get the formula right, please help! Thanks everyone!

 

[Joe4]

Welcome to the Board!

I don't think you need an IF statement at all. Just add this amount to the Contigency total. Adding a negative numbers is the same as subtracting a positive one.
So adding the value to the Contigency total should do what you want, regardless if it is postive or negative.

 

[DavidAdamB]

..............aaaaaand just like that, it's working. Perhaps I needed more coffee this morning. Thank you for the quick reply and the help, very much appreciated!!

 

[Joe4]

You are welcome.
Glad we were able to help!