Hello,
I need help creating a formula that will calculating monthly storage costs based on the storage date.
Each storage location costs $99 per month, I need the calculation to be based on the date of storage. The only conditions are every customer will receive the first month fee, except for 1 customer gets 3 months free (let's call them "customer one").
Cell E3= customer name (which will determine 1 or 3 months storage), cell H3 contains the storage date.
Thank you,
J
Screen Shot.png
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have uploaded the file.
Thank you,
Jen
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks