How to Create Custom Functions in Google Sheets
While Google Sheets provides you with hundreds of functions, it also allows you to create your own. Before, you could only do this using Apps Script. Now, there’s a user-friendly tool in your spreadsheet called Named Functions.
Using Named Functions, you title your function, give it a description, add argument placeholders, and enter the definitions. You can then use your custom functions across the sheets in your workbook and import them into other Google Sheets workbooks.
Create a Named Function in Google Sheets
To easily demonstrate how each of the setup elements works, we’ll walk through the process using an example. We’ll create a function that tells us whether or not to apply a bonus to our departments based on total sales.
Because the current array formula we’re using is a lengthy one, we’ll create a simplified version with our own custom function.
Note: Keep in mind that our example is simply for this guide. You can set up any type of function you want.
To get started, open a sheet and head to the Data tab. Select “Named Functions” which opens the sidebar where you’ll create your function.
Read Full Article Source