• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate cost per day basis category

Hi Team, I am looking for formula to calculate the cost that should charged for holding the package.
Below is the example .
for 0-5days no charge $0 charge
from 6thday to till 10th day it will $2 per day , so if its 7 days it would be 2days * $2 = $4 and for 10 days it would be $10
the catch is here
from its 11th to 15th day charge is $4 per day , considering 13th day, then it should calculate $10( for 5-10days) Plus $4 & 3days(11,12 & 13) = $12 and total should be $22.
Finally if its 16 days and above $8 per day , considering 18 days , then it should calculate $10 ( for 5-10days) plus $20 ( 11th to 15Th) and plus $8 * 3 days = $24 total cost $54.

Thank you for your help .
 
Back
Top