Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function teto() {
- var ss = SpreadsheetApp; //seta a planilha
- var planilhaAtiva = ss.getActiveSpreadsheet(); //torna-a ativa
- var abaAtiva = planilhaAtiva.getActiveSheet(); //seta a aba ativa
- for (var i = 2; i < 10; i++) {
- var cpf = [i][3];
- var valor = [i][11];
- if (cpf = cpf+1) {
- valor = valor + (valor + 1);
- abaAtiva.getRange(i,13).setValue(valor);
- }
- }
- }
Add Comment
Please, Sign In to add comment