patrickboileau
New Member
- Joined
- Feb 18, 2005
- Messages
- 2
Type// //1st payment // //Value// //Occurance// Payment//
Opening// //01/02/2002// //27,420.00// //1// 27,420.00//
Monthly// //02/03/2002// //32,904.00// //36// //914//
Yearly// //02/02/2003// //32,904.00// //2// 16,452.00//
Monthly// //02/12/2003// //82,260.00// //100// 1,557.49//
Yearly// //02/01/2005// //98,712.00// //6// 29,834.17//
I am looking for the most efficient way to expand this information into a payment table. The only way I know how is with "if" and date functions. CAN SOMEONE HELP ME? What would be the best way to set things up so that when the variables change everything works out nicely in the schedule.
THANKS A BUNCH!
PAt
Opening// //01/02/2002// //27,420.00// //1// 27,420.00//
Monthly// //02/03/2002// //32,904.00// //36// //914//
Yearly// //02/02/2003// //32,904.00// //2// 16,452.00//
Monthly// //02/12/2003// //82,260.00// //100// 1,557.49//
Yearly// //02/01/2005// //98,712.00// //6// 29,834.17//
I am looking for the most efficient way to expand this information into a payment table. The only way I know how is with "if" and date functions. CAN SOMEONE HELP ME? What would be the best way to set things up so that when the variables change everything works out nicely in the schedule.
THANKS A BUNCH!
PAt