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/func...