If the functional programming language requires that each expression must be exactly one line with no comments, I'll pass thanks. Long Excel formulas make Regex look like poetry.
This might sound like a hack, but being able to see intermediate results makes debugging complex expressions easier too, so in a sense it is working as intended.
Ctrl+Tilda toggles show/hide formulas, which helps identify input cells when you inherit a messy spreadsheet.
Also the number formats and locale settings can cause quite a bit of trouble, if its not English/US. Alot of data warehouse setups output files with U.S formats even in Europe.
It's not perfect, I wish it would automatically format that way, but it certainly makes maintenance easier.
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...