Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro Rate Billing Template for wireless plans
Hey, I would really appreciate if anyone has already an excel template that
calculates pro rates. Actually what i need is that when a customer changes his wireless plan during a billing cycle, to calculate the bill for his next bill which is minutes used with the previous plan x the cost of previous plan + minutes used with his new plan x the cost of his new plan. Thanks!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro Rate Billing Template for wireless plans
A B C
1 Plan 1 Plan 2 2 Plan Cost 49.99 69.99 3 Plan Minutes 500 1000 4 Cost Per Min =B2/B3 =C2/C3 5 Minutes Used 300 =((B2-((B3-B5)*B4))/C4) 6 Minutes Left =C3-C5 7 Total Credit/Due =B2-((B3-B5)*B4) =C2-(B2-((B3-B5)*B4)) You can change the data in cells that don't contain a formula. -- Regards, Alan "Jean" wrote in message ... Hey, I would really appreciate if anyone has already an excel template that calculates pro rates. Actually what i need is that when a customer changes his wireless plan during a billing cycle, to calculate the bill for his next bill which is minutes used with the previous plan x the cost of previous plan + minutes used with his new plan x the cost of his new plan. Thanks!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro Rate Billing Template for wireless plans
A B C
1 Plan 1 Plan 2 2 Plan Cost 49.99 69.99 3 Plan Minutes 500 1000 4 Cost Per Min =B2/B3 =C2/C3 5 Minutes Used 300 =((B2-((B3-B5)*B4))/C4) 6 Minutes Left =C3-C5 7 Total Credit/Due =B2-(B2-((B3-B5)*B4)) =C2-B7 Sorry, the formulas in the prior post were incorrect. Row 7 has changed. -- Regards, Alan "Jean" wrote in message ... Hey, I would really appreciate if anyone has already an excel template that calculates pro rates. Actually what i need is that when a customer changes his wireless plan during a billing cycle, to calculate the bill for his next bill which is minutes used with the previous plan x the cost of previous plan + minutes used with his new plan x the cost of his new plan. Thanks!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro Rate Billing Template for wireless plans
Were you able to use it?
-------------- Regards, Alan "Jean" wrote in message ... Hey, I would really appreciate if anyone has already an excel template that calculates pro rates. Actually what i need is that when a customer changes his wireless plan during a billing cycle, to calculate the bill for his next bill which is minutes used with the previous plan x the cost of previous plan + minutes used with his new plan x the cost of his new plan. Thanks!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pro Rate Billing Template for wireless plans
oops not really! but thanks a lot for ur post! I really appreciate it,
Jean. "Alan" wrote: Were you able to use it? -------------- Regards, Alan "Jean" wrote in message ... Hey, I would really appreciate if anyone has already an excel template that calculates pro rates. Actually what i need is that when a customer changes his wireless plan during a billing cycle, to calculate the bill for his next bill which is minutes used with the previous plan x the cost of previous plan + minutes used with his new plan x the cost of his new plan. Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template for Housing Society Maintenace Billing in India | New Users to Excel | |||
Is there a billing legder template for excel | New Users to Excel | |||
looking for template to track travel plans for 5 people | Excel Discussion (Misc queries) | |||
Where can I find a Billing Statement Template for Word or Excel? | New Users to Excel | |||
a template for medical billing cpt codes | New Users to Excel |