Hacker News new | ask | show | jobs
by pony_sheared 1950 days ago
The new Let() function gives you multi row formulas, with local variables.

https://insider.office.com/en-us/blog/let-names-in-formulas-...

And it's a hack, but you can put text comments inside an N() function and add them into your formulas.

https://support.microsoft.com/en-us/office/n-function-a624ca...