Skip to content

Instantly share code, notes, and snippets.

@wirasetiawan29

wirasetiawan29/Formula.text

Created October 11, 2014 11:52
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 wirasetiawan29/c192104bb0509274ff39 to your computer and use it in GitHub Desktop.
Save wirasetiawan29/c192104bb0509274ff39 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Formula.text
=IF(RIGHT(B6,1)*1=IF(MOD(IF(LEFT(B6,1)*2>9,(LEFT(B6,1)*2)-9,LEFT(B6,1)*2)+IF(MID(B6,3,1)*2>9,(MID(B6,3,1)*2)-9,MID(B6,3,1)*2)+IF(MID(B6,5,1)*2>9,(MID(B6,5,1)*2)-9,MID(B6,5,1)*2)+IF(MID(B6,7,1)*2>9,(MID(B6,7,1)*2)-9,MID(B6,7,1)*2)+IF(MID(B6,9,1)*2>9,(MID(B6,9,1)*2)-9,MID(B6,9,1)*2)+IF(MID(B6,11,1)*2>9,(MID(B6,11,1)*2)-9,MID(B6,11,1)*2)+IF(MID(B6,13,1)*2>9,(MID(B6,13,1)*2)-9,MID(B6,13,1)*2)+MID(B6,2,1)+MID(B6,4,1)+MID(B6,6,1)+MID(B6,8,1)+MID(B6,10,1)+MID(B6,12,1)+MID(B6,14,1),10)=0,0,(10-MOD(IF(LEFT(B6,1)*2>9,(LEFT(B6,1)*2)-9,LEFT(B6,1)*2)+IF(MID(B6,3,1)*2>9,(MID(B6,3,1)*2)-9,MID(B6,3,1)*2)+IF(MID(B6,5,1)*2>9,(MID(B6,5,1)*2)-9,MID(B6,5,1)*2)+IF(MID(B6,7,1)*2>9,(MID(B6,7,1)*2)-9,MID(B6,7,1)*2)+IF(MID(B6,9,1)*2>9,(MID(B6,9,1)*2)-9,MID(B6,9,1)*2)+IF(MID(B6,11,1)*2>9,(MID(B6,11,1)*2)-9,MID(B6,11,1)*2)+IF(MID(B6,13,1)*2>9,(MID(B6,13,1)*2)-9,MID(B6,13,1)*2)+MID(B6,2,1)+MID(B6,4,1)+MID(B6,6,1)+MID(B6,8,1)+MID(B6,10,1)+MID(B6,12,1)+MID(B6,14,1),10))),"VALID","TIDAK VALID")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment