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, ...
View more: How to Create Custom Functions in Google Sheets