I already use a formulain D2 that reads:
=MAX(0,C2-6)*17+MAX(0,C2-10)*33+MAX(0,C2-30)*50
This formula gives me the Amount to Charge(D2) for Days used at Origin(C2)
The Charges used in this formula are as follows:
The first 6 days are free
the 7th 8th 9th and 10th days are charged $17 a day
the 11th through the 29th day are charged $50 a day
the 30th day and above are charged $100 a day
FYI---->(17+33+50=100)
I need a formula that gives me the Days used at Destination.The problem Im
having is that I can't make the above formula work because the origin days
figure in and if the origin has used more than 6 days the 1st ten days at
destination are at $17(the rest of the charges are the same). eg: if the Days
used at Origin(C2) is 7, the Days used at Destination(K2) is 7. the Origin
charges should be for 1 day (17) and for 7 days at 17 (119) at Destination.
I need a formula to get the 119.

Any help comes Highly Appreciated!!!!!
I'll be checking on this post alot. If more info is needed please ask.

Thank you
Bryan J Bloom