title: How should I properly use the set range and get range functions in Google Apps Script?
body: <p>I need to update the value of "product quantity" based on the value of "order quantity" but only when "order sku" is equal to "product sku".</p>
  
  <pre><code>function productLoop2() {
  
    var app = SpreadsheetApp;
    var ss = app.getActiveSpreadsheet();
    var activeSheet = ss.getActiveSheet();
  
    var t = 2;
    var n = 2;
    var s = 0;
  
    for(var t = 2; t &lt; 52; t++) {
      var x = activeSheet.getRange(t, 1).getValue();
      //x is the ORDER SKU
      var r = activeSheet.getRange(t, 2).getValue();
     //r is the ORDER QUANTITY
      var q = activeSheet.getRange(n, 3).getValue();
      //q is the PRODUCT SKU  
      var u = activeSheet.getRange(n, 4).getValue();
      //u is the PRODUCT QUANTITY
  
      if (x != q) {
      n++;
      } else {
        s = u - r;
      }
        var m = activeSheet.getRange(n,4).setValue(s);
    }  
  </code></pre>
  
  <p>}</p>
  
  <p>I need the cell "n,4" (order quantity) to update so the value equals the result of "u"(product quantity) minus "r"(order quantity)</p>