Hi Excel Users,
I create a spreadsheet that displays 3 desinations. 2 of the destinations are fixed locations or has a fixed distance. The third desination can vary.
I'm trying to determine the total mileage if I go to Point A, B or C. I have a list of dates & by inserting a Y for Yes or N for No if destination was made.
I'm trying to figure a formula that can calculate the variable by using a bunch of "IF" formulas. I managed to get partially working, but I think my formula is negating one of my possible outcomes & thus, giving me a FALSE or incorrect answer.
I attached the spreadsheet for example.
Thanks for the assistance.
Bookmarks