The short answer seems to be no.
Following on Regina’s logic answer (a cell containing a formula is not empty because it contains the formula): because a cell returning “” is interpreted as containing Text you can use an IF(ISTEXT(A1);0;A1) condition to solve (some) problems.
I asked about returning empty cell because I want to use Ctrl + arrow. Not for using formula. Formula do well with empty cells.
Hi
My answer may be too late for this, sorry, but if the goal is:
Ctrl+Arrow should not find a cell displaying “” (result of a formula)
a solution could be to protect these cells (eg . apply a cell style) then Tools▸Protect▸Sheet▸uncheck Allow all users to Select protected cells.
Regards
I do not have a solution, but an opinion: THIS SHOULD BE SOLVED ADDING EXTRA VALUE, for an example EMPTY() which means that will be considered like 0 (zero) in every calculationts and will always look like empty. Solutions like =IF(B4=0;{};B4) or =IF(B4=0;"";B4) does not solve the problem, if the function is in cell A2, it must be calculated on cell A4: =A2+A3 now it returns #VALUE!. What is a bit amazing is that functtion =SUM(A2:A3) can calculate the value 0, even if A2 is {} or “”, but =A2+A2 cannot do this.
A better solution to the original question might be =IF(A1=0,"",A1)
=IF(A1=0,{},A1) fails if A1 changes from 0 (e.g. on adding new row) and is not allowed anyway - see response to my bug report.
My aim was to make a graph with discontinuities, and double quotes work for that: easily seen with =IF(A1=0,"",A1+1) in column B of a 2-column sheet.
=ISTEXT(TheCell) will return TRUE unlike for =IF(A1=0,{},A1) which works in many cases despite being “not allowed”.