In Calc, as in most spreadsheet applications, an IF() function exists that can be used to control behaviour, for example inserting this formula in cell C1.
will display A in C1 if the value in A1 exceeds the value in B2, otherwise it will display B. Likewise a cell containing a formula can be made to appear blank with something like this, which inserts an empty string when the cell should appear blank.
The problem is that this "blank" value can't be tested using the ISBLANK() function in another cell as ISBLANK() on a cell containing such a formula returns false no matter which of the values is displayed. My question is thus, what can be inserted into the true or false leg of an IF() function so that it will allow ISBLANK() on the cell to return true?
In other words, if the formula in C1 is
what value of X will result in the formula
=ISBLANK(C1) being true?