Help with decling balance formula

  • Thread starter Thread starter HankL
  • Start date Start date
H

HankL

I am trying to setup a worksheet with this scenrioas an example:

Opening Balance off $300 in Columun O6

First deduction of $30.00 in Columun N7

I want to show a declining balance as additional deductions are entered in
Columun N

Thank you in advance for your support.

HankL
 
Hi HankL,

If the deductions in Column N are +ve, try:
=O6-SUM(N7:OFFSET(N7,COUNT(N:N)-1,))
If the deductions in Column N are -ve, try:
=O6+SUM(N7:OFFSET(N7,COUNT(N:N)-1,))
If you know the last possible cell in Column N that will be used for the deductions, replace 'OFFSET(N7,COUNT(N:N)-1,)' with that
cell address. Using 'OFFSET(N7,COUNT(N:N)-1,)' returns a range based on the number of cells in Column N that have numeric values in
them, but the range thus calculated isn't reliable if there are numbers or dates above N7 or below the last legitimate deduction
cell.
 
Back
Top