Google Sheets For Loop with If Statement

This video illustrates how to create a FOR LOOP with an IF STATEMENT in the Google Sheets Script Editor. In this example we have a data set of check book orders for 3 different bank branches. The objective is to build a For Loop that will dynamically assign the correct Shipping Charge based on the branch location. Since the some of the locations have different shipping charges an If Statement is also created inside the for loop to assign the varying charges.

For a more detailed explanation of a For Loop in Apps Script for Sheets check out the link below to my website:
For Loop Explanation
Faster For Loop using the Map Method

Learn more about Google Apps Script with this Beginner's Guide Book at Amazon.
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below