Will Excel calculate difference between two columns ONLY when both are filled in?

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?

By: flyawaynet

Leave a Reply

Your email address will not be published. Required fields are marked *