cell formula not working to calculate the correct charge after 7 days

[steve400243]

Hello, I have the below formula used to calculate a charge after a certain amount of days (7), However it is not calculating the charge correctly, it goes to the min charge of $50.00 only for the first 5 days. If the Volume is larger it should calculate the past the min charge. It seems to work fine for the 12th day amount.

$3.50 per cbm, or $50 min charge for next 5 days, 12th day - additional $3.50 per cbm per day no min

Cell H4 - Start Date
H5 - effective storage date - 7th day after date in H4
H6 - 12th day

Cells F13 thru F35 - Volume, will be different in each row.
K13 - K35 - Pickup date

=IF(F13<0.01,0,ROUND(MAX(((K13-$H$6)*F13*3.5),0)+IF(K13-$H$4<7,0,MAX(((K13-$H$5)*3.5),50)),2))

Any help would be greatly appreciated.

 

[steve the fish]

If i understand test this:

=MAX(50,(MAX(0,K$13-$H$4-10)+MAX(0,K$13-$H$4-5))*3.5*$F13)

 

[steve400243]

If i understand test this:

=MAX(50,(MAX(0,K$13-$H$4-10)+MAX(0,K$13-$H$4-5))*3.5*$F13)

Thanks Steve, Getting closer I think, it is calculating now the correct storage, but it needs to stay the same amount for days 8 thru 12.
$3.50 per cbm, or $50 min charge for next 5 days, 12th day - additional $3.50 per cbm per day no min

 

[steve the fish]

How about some examples and expected results. It needs to stay the same makes no sense as surely that depends on the cbm???

 

[steve400243]

Here you go, thank you -

H4 - 01/01/2019
H5 - 01/08/2019 Storage Starts
H6 - 01/13/2019 12th Day

CBM Pickup date
F13 - 18.00 K13 - 01/09/2019 Charge should be - $63.00
F14 - 10.00 K14 - 01/09/2019 $50.00 Min charge
F15 - 18.00 K15 - 01/15/2019 $189.00 - $63.00 for first 11 days, + $126.00 for 13 days