JLLeitschuh/DistanceDictionaryCalculation

Created March 16, 2017 00:04

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/JLLeitschuh/e3e66137434c1cc9d3ffbfba551337de.js"></script>
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