You've been able to write custom formulas in VBA in Excel for a while now. The same functionality exists in Google Sheets with the much nicer macro language of

You've been able to write custom formulas in VBA in Excel for a while now. The same functionality exists in Google Sheets with the much nicer macro language of JavaScript. https://developers.google.com/apps-script/guides/sheets/functions https://developers.google.com/apps-script/guides/sheets/func...