At work, running Windows – Excel 2016
I dispute over-billed invoices and have a spreadsheet that I need to calculate the difference between two columns, but only AFTER both columns are filled in.
Column A Column B Column C
Billed Amt Corrected Amt Difference between the two
Total Column C $$$$
Unfortunately, Column C will give the same # as Column A if I haven’t finished the dispute and recieved the Corrected amount in Column B. Which throws my total off at the bottom.
Is there a way to make it not put an amt in column C until both A and B are filled?