3 ms·
> No trolling: What is wrong with that? Because you can't define a named custom formula by composing the built-ins. So every cell is just the same copy-pasted
by labcomputer 7mo ago
> No trolling: What is wrong with that?
Because you can't define a named custom formula by composing the built-ins. So every cell is just the same copy-pasted formula string. When you need to change something, you have to change it everywhere and pray that you didn't miss one usage.
I can't count how many times I found a bug in a spreadsheet because someone (who might be me) missed one or two instances.
- max51 7mo agoYes, you can define your own named custom formulas in Excel. I prefer to do it with VBA code because I find it easier to manage, but it's also possible without VBA using just the built-ins in the spreadsheet directly.