ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reduce balance (https://www.excelbanter.com/excel-discussion-misc-queries/258694-reduce-balance.html)

Nat

Reduce balance
 
How can i get the cell with my balance owed to subtract what payment I made
on the next cell?
--
nat

Toothsome Papa

Reduce balance
 
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.

"nat" wrote:

How can i get the cell with my balance owed to subtract what payment I made
on the next cell?
--
nat


Fred Smith[_4_]

Reduce balance
 
You subtract. If balance is in D2, and payment in C3, then new balance is:
=D2-C3

Regards,
Fred

"nat" wrote in message
...
How can i get the cell with my balance owed to subtract what payment I
made
on the next cell?
--
nat




All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com