Calculate a pro-rated amount
- What is it? This formula calculates a pro-rated amount, useful when subscribing customers to a service part way through a year. The amount is obtained by multiplying the days remaining in the year, the number of items and the cost per day.
Inputs
This formula requires 3 inputs:
- Days remaining
- Number of items
- Cost per day
Return values
This formula returns the result, to two decimal places, of multiplying:
Days remaining x Number of items x Daily cost
Formula Logic
- The formula multiplies the three inputs together