Google Sheets Create Custom Function with Condition

This video displays how to create a Custom Function in Google Sheets that contain an IF Statement. In this example there are monthly sales figures for a set of employees and the objective is to create a Custom Function that calculates a Sales Bonus amount based on Employee Monthly Sales Threshold amounts. Any employee who sold 12,000.00 or more gets a 25% bonus. Any employee who sold under 12,000.00 but 10,000.00 receives a 15% bonus. Anyone with monthly sales of less than 10,000.00 does not receive a bonus. Learn more about Google Apps Script with this Beginner's Guide Book at Amazon. https://amzn.to/3MMvDZs DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below #GoogleSheetsCustomFunction #GoogleSheetsCustomFunctionWithCriteria #GoogleSheetsCustomFunctionWithCondition