Skip to content

Instantly share code, notes, and snippets.

/gist:e0f1cb5d34b8ef2b81c9109f013d2073 Secret

Created January 9, 2017 14:37
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 anonymous/e0f1cb5d34b8ef2b81c9109f013d2073 to your computer and use it in GitHub Desktop.
Save anonymous/e0f1cb5d34b8ef2b81c9109f013d2073 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
=VLOOKUP($G2,新特休對照!$A$2:$B$7,2,TRUE)+INT(($G2>=10)*($G2<25)*($G2-9))+INT(($G2>=25)*15)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment