Need help with an excel formula

mrcsbenson

New Member
Joined
May 8, 2024
Messages
12
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
I am looking to create a excel formula on "Total Possible Risk" of money for ULD Control using todays date, charge per day, total spend per week and total possible risk up to 180 days . What type of formula would I create?

Here is what I have:

1738618773103.png


Column E: Date of ULD being sent to me
Column F: Date the ULD should be given back to carrier =ABS(E2+8)
Column G: Todays Date
Column H: Formula calculating the dates and turning into a number =ABS(E2-G2)
Column I: Charge (From Carrier) per day of us having the ULD past 8 days
Column J: Total charge =SUM(H2*25)
**Column K: ??? Is what I have correct? Total spend per week =SUM(25*7)
**Column L: ???

I need help with Column K and L. I am looking to see if I set up the formula correctly in Column K and if I didn't what should be the correct formula? I am also looking to see what should column L formula be if I want to do a possible total risk of what we would pay up to 180 days with us not returning any ULDs. Hopefully I explained that correctly.
 

Attachments

  • 1738618744815.png
    1738618744815.png
    8.5 KB · Views: 3

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Hello,

If I am understanding you correctly you have some extra items in your formulas.
How I would set them up:
Column E: Date of ULD being sent - Manually Inputted
Column F: Date the ULD should be given back to carrier =E3+8
Column G: Todays Date - Manually Inputted
Column H: Formula calculating the dates and turning into a number =G3-E3 Have the column formatted as a number.
Column I: Charge (From Carrier) per day of us having the ULD past 8 days - Manually Inputted
Column J: Total charge =H2*I2
Column K: assuming this is the amount charged after holding for 8 days ($25 a day) =I3*7
Column L: assuming this is the amount charged after holding for 8 days being projected to what would be 180 days. =I3*180

Let me know if I misunderstood any of what the data represents.
 
Upvote 0
Solution
Thank you...You actually worked this out for me. I think I messing it up for myself. Thank you
 
Upvote 0
Glad I could help!
Its easy to get wrapped in our heads and overcomplicate things :)

Please don't forget to mark this as solved.
 
Upvote 0
@mrcsbenson
In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread as I have changed the marked solution.


Please don't forget to mark this as solved.
@Jette3173
Note that in the MrExcel forum we do not mark threads as solved but rather mark the actual solution post, if there is one.
 
Upvote 0
@Peter_SSs thank you for clarifying that for me!
 
Upvote 0

Forum statistics

Threads
1,226,453
Messages
6,191,136
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top