Skip to content

Instantly share code, notes, and snippets.

@michaelsproul

michaelsproul/excel_tax.xlsx

Created May 2, 2019 07:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michaelsproul/c720617de996ba41e35349c9304826b4 to your computer and use it in GitHub Desktop.
Save michaelsproul/c720617de996ba41e35349c9304826b4 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Nightmares
Raw
excel_tax.xlsx
IF(EXACT($C12, "Sell"), IF($E12 - $I12 < VLOOKUP($K12, $A$1:$N$146, 5) - SUMIF($H$2:$H11, $H12, $I$2:$I11) - SUMIF($K$2:$K11, $K12, $L$2:$L11), $E12 - $I12, VLOOKUP($K12, $A$1:$N$146, 5) - SUMIF($H$2:$H11, $H12, $I$2:$I11) - SUMIF($K$2:$K11, $K12, $L$2:$L11)), "")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment