Forum Discussion
Brandon Becker
Aug 24, 2018Copper Contributor
Excel Formula Help (I assume SUM IF)
I copied this spreadsheet from a website into an Excel spreadsheet. I need to be able to edit the Paid column but need the formula in the Balance column to adjust to an accurate result. The Team...
Lorenzo Kim
Aug 25, 2018Bronze Contributor
try this simple formula at G2 (Balance) =IF(E2=0,F2-D2+E2-B2-C2,D2+E2-B2-C2)
(copied down) ... thanks