Although Google Sheets has more than 400+ built-in functions, I love to show folks how you can create custom functions that you can write for custom problems.
Source: Auto-calculate rooms needed for a conference in a Google Sheet via an Apps Script
The latest from the Google Apps Script and Google Workspace developer community
