Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
=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
You can’t perform that action at this time.