How do I set up a formula to prorate a monthly bill?

  • Thread starter Thread starter DarylMB
  • Start date Start date
D

DarylMB

-----Original Message-----
How do I set up a formula to prorate a monthly bill? Preferably in Excel.
Thanks all and GOD BLESS YOU ALL!

Phil
.
Not sure what you mean by "prorate" but if you have a
Click to expand...
bill for January that is $200.00, then enter the formula
=200/31 to see the amount for each day of January. Then
multiply that amount ($6.45 in this case) by the number
of days to get your prorated amount. For example, from
January 1-10 inclusive the amount would be 6.45*10 or
$64.50.
 
Back
Top