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.
Source: howtogeek.com