The point I make is that the impact on NPV and IRR functions of empty and blank cells in the range is such that this is an important pre-calculation requirement for robust analysis. SergeiBaklanTwo problems you'
The point I make is that the impact on NPV and IRR functions of empty and blank cells in the range is such that this is an important pre-calculation requirement for robust analysis. SergeiBaklanTwo problems you've referred to Sergei. We do have a fully functional function that returns TRUE...
COUNTEMPTY Returns the number of empty cells. Obviously, My ISEMPTY would have exactly the same algorithm as ISBLANK - it's just more appropriately named. My COUNTEMPTY on the other hand is really new and returns the number of empty cells. In case you think this is semantics, you should ...
It's easy to program a UDF to allow (e.g.) =MYCOUNTEMPY(B11:B19) but wouldn't it be better for Developers to give us this very commonly needed function. The point I make is that the impact on NPV and IRR functions of empty and blank cells in the range is such that this is ...