Create Apps Script custom functions How to get the total amount of items including the tax rate

How to get the total amount of items including the tax rate  CALC_TOTAL_AMOUNT Product Price Quantity Tax Rate Subtotal Total Amount Product A 10 5 0.08 4 54 Product B 20 3 0.05 3 63 Product C 15 2 0.1 3 33 Total 150 In this example, we’ll create a custom formula that calculates the … Read more

Google Sheets get Data from two sheets to use within a custom function

How to use data from two sheets to create a custom Apps Script function  CALC_TOTAL_COST_WITH_TAX function getTaxRate(category) { const sheets = SpreadsheetApp.getActive().getSheetByName(‘TaxTable’); const taxTable = sheets.getDataRange().getValues(); let tax = 0 taxTable.forEach(val =>{ if (val[0] == category) { tax = val[1]; } }) return tax; } function test(){ Logger.log(getTaxRate(‘Category 1’)) } Category Tax Rate Category 1 … Read more

Get the total cost custom sheets formula calculate values across ranges

In this tutorial, we walk you through the creation of a custom formula using Google Apps Script in Google Sheets, allowing you to automatically calculate total costs for items and generate an overall expenditure. Summary: Managing calculations in spreadsheets becomes a breeze with this custom formula: Step 1 – Setup: Step 2 – Writing Code: … Read more

Calculate a weighted Average from a range of values

WEIGHTED_AVERAGE  Value Weight 10 0.1 15 0.1 5 1 Result 6.25 Scenario: You want to create a custom Google Sheets formula that calculates the weighted average of values in a specified range, where each value is multiplied by its corresponding weight. Data Table: A B C 1 Value Weight 2 10 0.3 3 15 0.5 … Read more

Calculate average from range above a threshold

AVERAGE_ABOVE_THRESHOLD 7 4 9.333333333 6 10.66666667 15 11.33333333 11 8 In this example, we’ll create a custom formula that calculates the average of a range of numbers, excluding any values that are less than a specified threshold. Scenario: You have a range of numbers in column A and a threshold value in cell B1. You … Read more

Learn New Skills for 2022 Web development Course Deals 3 FREE Courses Bonus

https://www.linkedin.com/pulse/learn-new-skills-2022-web-development-course-deals-laurence-svekis-/?trackingId=IqK89WbOQE2LwcTvqA20Lw%3D%3D Bonus 3 FREE courses at the bottom of this newsletter!!! Now is the time to learn something new, or expand your knowledge! Use the promo code LEARNTODAY2022 to get the below courses for the BEST PRICE POSSIBLE, hurry this offer is only available for the next 72 hours. Did you want to more about coding and web development … Read more

Free Book on Amazon Learn Google Apps Script

Are you looking for more Google Apps Script resources to continue learning? Just released – New book on Amazon about Google Apps Script and its FREE on Amazon for the next 3 days only. Getting Started with Google Apps Script: How to create amazing time saving applications within your Google Workspace with Apps Script 25+ New YouTube Videos about Google Apps Script and how to … Read more

Getting Started with Google Sheets for Beginners Quick Introduction to workspace Spreadsheets online

Getting Started with Google Sheets for Beginners Quick Introduction to workspace Spreadsheets online

Learn more and get Help with Google Sheets Online Quick Tip How to Get Help with Sheets training

Learn more and get Help with Google Sheets Online Quick Tip How to Get Help with Sheets training