Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of monthly installments
I have a number of customers with multiple invoices that they want to pay by installments. How can I create a simple ready reckoner that will calculate the sum of each invoice installment that will be due each month. eg Invoice 1 £100: Jan£33.33 Feb£33.33 Mar£33.33 Invoice 2 £300 Feb£100 Mar£100 Apr£100 Invoice 3 £900 Mar£300 Apr£300 May£300 Total per month Jan £33.33 Feb £133.33 Mar £433.33 Apr £400.00 May £300.00 -- Emilystorey ------------------------------------------------------------------------ Emilystorey's Profile: http://www.excelforum.com/member.php...o&userid=31534 View this thread: http://www.excelforum.com/showthread...hreadid=556941 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of monthly installments
If monthly payments are their own column, can't you simply total the column?
Col A is Invoice number , Col B = Jan payments, Col C =Feb payments etc so simply put =SUM(B:B) or SUM(B2:B200) in appropriate cell If not, how is the data organised? HTH "Emilystorey" wrote: I have a number of customers with multiple invoices that they want to pay by installments. How can I create a simple ready reckoner that will calculate the sum of each invoice instalment that will be due each month. eg Invoice 1 £100: Jan£33.33 Feb£33.33 Mar£33.33 Invoice 2 £300 Feb£100 Mar£100 Apr£100 Invoice 3 £900 Mar£300 Apr£300 May£300 Total per month Jan £33.33 Feb £133.33 Mar £433.33 Apr £400.00 May £300.00 -- Emilystorey ------------------------------------------------------------------------ Emilystorey's Profile: http://www.excelforum.com/member.php...o&userid=31534 View this thread: http://www.excelforum.com/showthread...hreadid=556941 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation of monthly installments | Excel Discussion (Misc queries) | |||
Mortgage calculation after a large extra payment | Excel Discussion (Misc queries) | |||
Mortgage calculation after a large extra payment | Excel Worksheet Functions | |||
Fv & Emi! | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) |