Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Service Charge Allocation
Can any body write a formula to spread the services charge. For example
Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is 16th Jan then Jan only 16 days and balance to go to colum Jan next year. I use this formula: =IF($A5<E$2,(IF($B5<E$2,0,(((IF($A5<E$2,(DAY(E$2)) ,((DAYS360($A5,E$2)+1)))/$C5*$D5))))),0). formula works but if I take the start date as 16 Jan doesn't calculate for 16 days. Any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Service Charge Allocation
Hello waseem
Should the service charge per month vary with the days in that month, e.g. Feb charge would be less than April and April would be less than May? It probably helps if you explain what's in cells A5:D5 and E2 "waseem" wrote: Can any body write a formula to spread the services charge. For example Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is 16th Jan then Jan only 16 days and balance to go to colum Jan next year. I use this formula: =IF($A5<E$2,(IF($B5<E$2,0,(((IF($A5<E$2,(DAY(E$2)) ,((DAYS360($A5,E$2)+1)))/$C5*$D5))))),0). formula works but if I take the start date as 16 Jan doesn't calculate for 16 days. Any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Finance Charge | Excel Discussion (Misc queries) | |||
Allocation | Excel Worksheet Functions | |||
Priority Charge | Excel Discussion (Misc queries) | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
F-key allocation | Excel Discussion (Misc queries) |