I need to be able to show incremental charges over a period.

To make things simple say I had a product rented at £100 for 120 days the
charges are as follows

0 - 5 days = Free of charge
6 to 25 days = 0.024% of product value
26 to 130 days = 0.036% of product value
131+ = 0.048%

The columns are

A - Product B - Value C - Rental Start Date D - Days rented

I've got the If calclautions but it gives a total of the 26 to 130 days from
day 1:

=IF(I4<=5,"FOC",IF(I4<=25,SUM(H4*0.00024),IF(I4<=1 30,SUM(H4*0.00036),IF(I4=131,SUM(I4*0.00048)))))

Help

Thanks