Excel Calculations

[chugger93]

I need some help, I dont know much about the calculations in excel. Basically I have a spreadsheet with a few columns, rows that has to do with paying a loan back. Every month I make a payment. I have the total and I basically want every months payment subtracted from the total amount.

Theres also an extra column for extra payments. So maybe an if condition or something saying "if that field is filled in with a number" then add it to the subtraction amount for that month.

You'll get a better idea of looking at the attached zip file. Any help is apprecate, thanks!

[mrice]

Have a look at the attached. Copy the formula in yellow down as the months go by.

[chugger93]

Thanks mrice,

however when I do the copy for all the rest of the cells, it shows $600 in every single column/row and the 20,0000.

I think I'd rather have it so all that doesnt show up, but only shows up when you enter in a payment for that month

[mrice]

OK, try these amended formula which check if there is a value in B first

=IF(B6<>"",SUM($B$3:C6),"")

=IF(B6<>"",$F$3-E6,"")

[chugger93]

that seems to work thanks.

Now when I copy all these formulas down, I have to change the cell numbers in all the formula's Ive noticed. Any simple way to do this, Im just doing it manually in each cell.



EDIT: n/m, use copy and paste special huh?

[mrice]

You can fix portions of the formula by use of the $ sign before either the letter or number.

If I had understood your question correctly, then the existing formulae do this. Maybe I misunderstood?