MARKEGANDERSON
Active Member
- Joined
- Apr 7, 2007
- Messages
- 264
Hello Guys,
I am trying to come up with a formula for each Uber Routes.
For Example,
A4 = Pick up, C4 = Drop off
B4 = Mileage
How would I approach this?
I was thinking nested Ifs(but that's a lot of variables)
Any ideas?
I am trying to come up with a formula for each Uber Routes.
For Example,
- Route A to B = 4.5 miles
- Route B to A = 4.5 miles
- Route A to C = 10 Miles
- Point C to A = 10 miles
A4 = Pick up, C4 = Drop off
B4 = Mileage
How would I approach this?
I was thinking nested Ifs(but that's a lot of variables)
Any ideas?