N nat Mar 11, 2010 #1 How can i get the cell with my balance owed to subtract what payment I made on the next cell?
T Toothsome Papa Mar 11, 2010 #2 let's say your balance owed is 100, and your payment was in cell B1, then you would enter =100-A1 in the cell If you tell us more about what you are trying to do, there are probably much better ways to do this calculation.
let's say your balance owed is 100, and your payment was in cell B1, then you would enter =100-A1 in the cell If you tell us more about what you are trying to do, there are probably much better ways to do this calculation.
F Fred Smith Mar 12, 2010 #3 You subtract. If balance is in D2, and payment in C3, then new balance is: =D2-C3 Regards, Fred
