Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. function onEdit(e) {
  2. var Column1 = 1
  3. var Column3 = 3;
  4. if (e.range.getColumn() == Column3) {
  5. e.range.setValue(Column1 * Column3)
  6. }
  7. }
  8.  
  9. function onEdit(e) {
  10. var sheet = SpreadsheetApp.getActiveSheet();
  11. var dataRange = sheet.getRange("A:C");
  12. var data = dataRange.getValues();
  13. for (var i = 0; i < data.length; ++i) {
  14. var rowData = data[i];
  15. var Column1 = rowData[0];
  16. var Column3 = rowData[2];
  17. if (e.range.getColumn() == Column3) {
  18. e.range.setValue(Column1 * Column3)
  19. }
  20. }
  21. }
  22.  
  23. function onEdit(e) {
  24. var Column1 = 1
  25. var Column3 = 3;
  26. if (e.range.getColumn() == Column3) {
  27. e.range.setValue(e.value * e.range.offset(0, Column1 - Column3).getValue());
  28. }
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement