RicardoCubed
Board Regular
- Joined
- Jul 10, 2013
- Messages
- 206
- Office Version
- 365
- Platform
- Windows
Hi out there in excel land. I am looking for help with a formula (non VBA) for E2 copied down and across to distribute amount by criteria selected. Example below with results.
Appreciate in advance any help.
Thank you.
<tbody>
</tbody>
Appreciate in advance any help.
Thank you.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Months in Contract | Month Start | Payment Frequency | Amount | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
2 | 1 | 2 | Monthly | 2,247.00 | 2,247 | 2,247 | |||||||||||
3 | 6 | 4 | Monthly | 19,764.00 | 3,294 | 3,294 | 3,294 | 3,294 | 3,294 | 3,294 | 19,764 | ||||||
4 | 12 | 1 | Quarterly-End | 45,444.00 | 11,361 | 11,361 | 11,361 | 11,361 | 45,444 | ||||||||
5 | 3 | 11 | Monthly | 11,271.00 | 3,757 | 3,757 | 7,514 | ||||||||||
6 | 11 | 3 | Quarterly-Beginning | 36,190.00 | 9,048 | 9,048 | 9,048 | 9,048 | 36,190 | ||||||||
7 | 7 | 5 | Monthly | 19,992.00 | 2,856 | 2,856 | 2,856 | 2,856 | 2,856 | 2,856 | 17,136 | ||||||
8 | 11 | 6 | Quarterly-End | 36,190.00 | 9,048 | 9,048 | 9,048 | 27,143 |
<tbody>
</tbody>
Sheet1