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