Hi All,
I have encountered an anomoly that I simply can't explain.
In the very simple attached workbook I am testing the range B6:C6 is the contents are blank by using the internal IsBlank() function.
As you can see the formula in cell B3 (above the test range) returns the expected result, whereas, the formula in cell D6 (to right of test range) returns an unexpected (by me anyway) result.
Is there something I'm missing here? (obviously!)
I have a work-around, but a technical explanation would be appreciated (maybe some examples of how to deal with this, if not at first glance obvious).
Thank you in advance.
Frank McDonald