Skip to content

Instantly share code, notes, and snippets.

View franklinbaldo's full-sized avatar

Franklin Silveira Baldo franklinbaldo

  • Procuradoria Geral do Estado de Rondônia
  • Porto Velho, Rondônia
  • X @franklinbaldo
View GitHub Profile
0x501A75d969796b027bf808e880F6487b109310e7
@franklinbaldo
franklinbaldo / gist:49d0c1710eee916db5417ddfa0887426
Last active June 16, 2017 02:04
FORMULA PARA VALIDAR CNPJ NO GOOGLE SPREESHET

cnpj

=AND(text(mod(sum(ARRAYFORMULA(ARRAYFORMULA(right(left(A2;{1;2;3;4;5;6;7;8;9;10;11;12});1)){6;7;8;9;2;3;4;5;6;7;8;9}));11);"0")=text(right(left(A2;13);1);"0");RIGHT(text(mod(sum(ARRAYFORMULA(ARRAYFORMULA(right(left(A2;{1;2;3;4;5;6;7;8;9;10;11;12;13});1)){5;6;7;8;9;2;3;4;5;6;7;8;9}));11);"0");1)=text(right(A2;1);"0"))

cpf

=AND(RIGHT(TEXT(mod(SUM(ARRAYFORMULA(ARRAYFORMULA(RIGHT(LEFT(A4;{1;2;3;4;5;6;7;8;9});1))*{10;9;8;7;6;5;4;3;2}))10;11);"0");1)&RIGHT(TEXT(mod(SUM(ARRAYFORMULA(ARRAYFORMULA(RIGHT(LEFT(A4;{1;2;3;4;5;6;7;8;9;10});1)){11;10;9;8;7;6;5;4;3;2}))*10;11);"0");1)=right(A4;2);ARRAYFORMULA(AND({1;2;3;4;5;6;7;8;9;10;11}*11111111111<>A4)))

Verifying that "franklinbaldo.id" is my Blockstack ID. https://onename.com/franklinbaldo

Keybase proof

I hereby claim:

  • I am franklinbaldo on github.
  • I am franklinbaldo (https://keybase.io/franklinbaldo) on keybase.
  • I have a public key whose fingerprint is A362 99FC CB1B F7AF B55B 0171 F8B9 CDF7 83FA F7D7

To claim this, I am signing this object: