I have a Workbook with 13 Sheets named TUITION, JANUARY, FEBRUARY, MARCH and so on till December. Trying to enter a Formula to get ending balance from January, subtract February Payment and get the new outstanding balance for February and repeat every Month, until hole tuition is paid off. . All values are fixed amounts, no interest. PMT arrangement vary, some are Weekly, Bi-Weekly or Monthly.
sory fi I could not be more clear, I am new to MrExcel and I am a beginner in Excel.
what I am trying to do is create a formula to get January ending balance and enter it i a cell in February to get the principal amount and subtract the amount paid in February to find the Outstanding balance and repeat Month after Month until reach Zero balance. This is the formula I am trying to work with, = IFERROR(IF(($D$4-E8)=0, 0, ($D$4-E8)),JAN!E8-F8)
sory fi I could not be more clear, I am new to MrExcel and I am a beginner in Excel.
what I am trying to do is create a formula to get January ending balance and enter it i a cell in February to get the principal amount and subtract the amount paid in February to find the Outstanding balance and repeat Month after Month until reach Zero balance. This is the formula I am trying to work with, = IFERROR(IF(($D$4-E8)=0, 0, ($D$4-E8)),JAN!E8-F8)
| NEW FEE TUITION COLLECTION VANGUARD.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 3 | STUDENT TUITION COLLECTION SYSTEM | |||||||||
| 4 | TUITION | $4,575.00 | A.Y. | 2021 | ||||||
| 5 | ||||||||||
| 6 | WEEK 1 PMT AMT | WEEK -2 PMT AMT | WEEK-3 PMT AMT | WEEK-4 PMT AMT | TOTAL PAID | BALANCE DUE | ||||
| 7 | MONDAY/WEDNESDAY | |||||||||
| 8 | ANKIE B | 4575 | PAID IN FULL | |||||||
| 9 | FABIAN O | $50.00 | $50.00 | 4575 | ||||||
| 10 | JUDE A | $300.00 | $300.00 | 4575 | ||||||
| 11 | PANKY J | 4575 | ||||||||
| 12 | LOUDIA T | $1,000.00 | $1,000.00 | 4575 | ||||||
| 13 | MAGALY P | 4575 | ||||||||
| 14 | MARTHA O | $1,000.00 | $1,000.00 | $2,000.00 | 3575 | |||||
| 15 | PATRICIA J | 4575 | ||||||||
| 16 | ISLANDES C | 4575 | ||||||||
| 17 | ROSELINE M | 4575 | ||||||||
| 18 | TUESDAY | 4575 | ||||||||
| 19 | ROMMEL Y | 4575 | ||||||||
| 20 | SCHIFANE P | |||||||||
| 21 | ANA C | |||||||||
| 22 | ANDREA M | |||||||||
| 23 | FANIE S | |||||||||
| 24 | IGOR B | |||||||||
| 25 | FRIDAY | |||||||||
| 26 | PAULA H | |||||||||
| 27 | GERARD D | |||||||||
| 28 | GUSTAVE L | |||||||||
| 29 | ALGERTE E | |||||||||
FEB | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G8:G19 | G8 | = IFERROR(IF(($D$4-E8)=0, 0, ($D$4-E8)),JAN!E8-F8) |
| F8:F29 | F8 | =IF(SUM(B8:E8)=0, "", SUM(B8:E8)) |
Last edited by a moderator:
