3 ms·
One aspect that Excel almost seems to enforce for any significantly complex computation is... testing. If you don't known have test input (e.g. an array of val
by kurthr 4y ago
One aspect that Excel almost seems to enforce for any significantly complex computation is... testing.
If you don't known have test input (e.g. an array of values) for which you have known output to observe for such an opaque programming language, you will be bitten! This innovation just makes it even more important.
That said Excel lets non-programmers create visual representations of data on a regular basis, and everyone has it on their desktop so there's no, "I can't use this" excuse.
- Tagbert 4y agoI tend to deal with that by using intermediate calculations. I can verify subsets of the formula and then use the results of those subsets in the next stage of the overall formula