• 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.

code to populate storage amount due after certain date

S

steve400243

Member
Hello, On the attached workbook i'm needing to have the storage rate populate in the storage field. this would stop calculating, and keep the current amount, when the p/u date is entered. Rates are highlighted. and would start calculating by the Devanned Date. Any ideas on this would be a great help. I tried to do this with formulas and it proved to be a mess. I have the desired result manually entered in Column Q. Thanks for all ideas.

Storage rate is highlighted in yellow. Please let me know if more information is needed. This would run for the entire sheet - Rows 11 thru 35
 

Attachments

  • storage test.xlsm
    21.8 KB · Views: 4
What about this formula:

=MAX(((J11-$H$6)*F11*3.5),0)+IF(J11-$H$4<7,0,MAX(((J11-$H$5)*3.5),50))

Pasted in Q11 and drag to fill.
 
That seems to work great. Thank you very much, I had a whole bunch of =if statements and it was very messy. I appreciate your time.
 
You must log in or register to reply here.
Back
Top