View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
waseem waseem is offline
external usenet poster
 
Posts: 2
Default 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