Skip to content

Instantly share code, notes, and snippets.

@JLLeitschuh

JLLeitschuh/DistanceDictionaryCalculation

Created March 16, 2017 00:04
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JLLeitschuh/e3e66137434c1cc9d3ffbfba551337de to your computer and use it in GitHub Desktop.
Save JLLeitschuh/e3e66137434c1cc9d3ffbfba551337de to your computer and use it in GitHub Desktop.
Download ZIP
A bit of code used in excel to help my mom calculate the distance she drove for work and medical miles in a given year to help fill out her tax returns.
Raw
DistanceDictionaryCalculation
=IF(N3="",IF(ISNA(VLOOKUP(B3,'Distance Dictionary'!$A$3:$B$129,2, FALSE)),"",VLOOKUP(B3,'Distance Dictionary'!$A$3:$B$129,2, FALSE)),IF(OR(M3="Two Way", M3="two way"),"",N3))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment