Forum Discussion
Sulzeer
Nov 06, 2023Copper Contributor
Need help for Excel formula with multiple criteria
Hey Hopefully there some people smarter than me:p I have case where I like to calculate indivdiual cost based how far from the gate they live. The person that live the farest from gate is at ...
HansVogelaar
Nov 06, 2023MVP
Does this do what you want?
Sulzeer
Nov 08, 2023Copper Contributor
Hey HansVogelaar
Didnt work for the data I have. I put in my data in you excel sheet som you can se,
I dont think it willl work for linear calculations without an higher start value for the people nearest gate.
So I will try som exponential equasions.
S
- HansVogelaarNov 08, 2023MVP
If you want more help, you'll have to explain in detail how you want to assign the costs.