=if code, or Macro, Question

[steve400243]

I have a worksheet i need help with, - I need to calculate storage for items received after 7 free calendar days, then $3.50 per CBM, Min of $50.00, for the next 5 days, - on the 12th day it goes to $3.50 per CBM per day. Currently i'm using a bunch of =If( codes, but think there has to be a better way.Thank you.

received day is cell - H4
7th day date is - H5
12th date is - J5
CBM is in - F11:F26
and the storage rate cell is P11:P26

I would appreciate any ideas you may have.

 

[burns14hs]

If the If() statements are working then I wouldn't see a real reason to change that. Is there a specific reason why you would like to make a change? i.e. worksheet extremely slow to calculate, etc.

 

[steve400243]

If the If() statements are working then I wouldn't see a real reason to change that. Is there a specific reason why you would like to make a change? i.e. worksheet extremely slow to calculate, etc.

No Specific reason, Just trying to gain more Excel Knowledge.