Re:Stop Using Excel, Finance Chiefs Tell Staffs
by linearithmic on Wednesday November 22, 2017 @11:59AM
(#15758310)
One reason why Excel should never be used for anything real is because it lacks type safety. For example if you have to sum a columns of numbers and one of them was mistakenly input as text, rather than throwing an error, it will just ignore that entry. There are lots of other problems related to type safety as well.
[ Parent
| on HN ]
Re:Stop Using Excel, Finance Chiefs Tell Staffs
by ZenoArrow on Wednesday November 22, 2017 @12:40PM
(#15758706)
For example if you have to sum a columns of numbers and one of them was mistakenly input as text, rather than throwing an error, it will just ignore that entry.
There are ways around that. Here's something I just put together as an example:
=EXACT(COUNT(A2:A6),COUNTA(A2:A6))
That will only return true if all the cells in range A2:A6 contain numbers.
There are other approaches that would work, if that doesn't suit you.