I need an Excel formula to return an empty cell, however it seems that Excel treats a reference to an empty cell or an empty string differently from an actual empty cell. In essence, I require something like:
I tried to do things such as
and assuming B1 is an empty cell
I assume they are the outcome of a formula, but none of these seem to be genuine empty cells. Is it possible to maintain a cell genuinely empty and only fill it with data if and when a certain condition is met?