mrcsbenson
New Member
- Joined
- May 8, 2024
- Messages
- 12
- Office Version
- 365
- 2021
- Platform
- 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:
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.
Here is what I have:
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.