HEEEELLLLP! Payment Schedule Problem

[patrickboileau]

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

 

[vane0326]

It was discussed in this thread.

http://www.mrexcel.com/board2/viewtopic.php?t=131688&highlight=#javascript:void(0);