Ali_Toronto
New Member
- Joined
- Dec 29, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello Everyone,
It’s my first time here, so I would like to thank everyone in advance for bearing with me and helping me out.
Here’s what I’m trying to do … in as simple terms as I can explain … the problem is much complex …
EXAMPLE:
Client has to pay $30,000 (or whatever)
He has 10 months to pay (or whatever)
His monthly payment amount is consistent
How do I calculate his last payment using a formula?
Since I can’t post a spread sheet – here’s how I have it setup
--- A3 TO B14 ---
TOTAL PAYMENT
BASE PAYMENT
PAYMENT 1
PAYMENT 2
PAYMENT 3
PAYMENT 4
PAYMENT 5
PAYMENT 6
PAYMENT 7
PAYMENT 8
PAYMENT 9
PAYMENT 10
--- B3 TO B7 ---
$30,000.00
$9,000.00
=B4
=B4
=IF(SUM($B$5:B6)<$B$3,$B$4,($B$3-(SUM($B$5:B6))))
--- B7 TO B14 --- DRAG AND FILL FORUMLA ABOVE
I’m usually pretty good at performing my own research for excel problems, but I’ve really been stuck on this one for a while – I’ve tried many different formulas, possibilities … but I can’t seem to figure it out ….
In advance, please be nice … I’m no expert at excel.
It’s my first time here, so I would like to thank everyone in advance for bearing with me and helping me out.
Here’s what I’m trying to do … in as simple terms as I can explain … the problem is much complex …
EXAMPLE:
Client has to pay $30,000 (or whatever)
He has 10 months to pay (or whatever)
His monthly payment amount is consistent
How do I calculate his last payment using a formula?
Since I can’t post a spread sheet – here’s how I have it setup
--- A3 TO B14 ---
TOTAL PAYMENT
BASE PAYMENT
PAYMENT 1
PAYMENT 2
PAYMENT 3
PAYMENT 4
PAYMENT 5
PAYMENT 6
PAYMENT 7
PAYMENT 8
PAYMENT 9
PAYMENT 10
--- B3 TO B7 ---
$30,000.00
$9,000.00
=B4
=B4
=IF(SUM($B$5:B6)<$B$3,$B$4,($B$3-(SUM($B$5:B6))))
--- B7 TO B14 --- DRAG AND FILL FORUMLA ABOVE
I’m usually pretty good at performing my own research for excel problems, but I’ve really been stuck on this one for a while – I’ve tried many different formulas, possibilities … but I can’t seem to figure it out ….
In advance, please be nice … I’m no expert at excel.