Answer the question
In order to leave comments, you need to log in
How can I return the value of an empty cell using a formula?
It is necessary that, according to the condition, the cell has either a value or is empty (but not ""
).
Answer the question
In order to leave comments, you need to log in
I like the reference to an empty range the best. Just create a named range, in my case it is BLANK
, which refers to some always empty cell. Further, for example, in B1
=IF(A1=1;BLANK;A1)
If to C1
add =ISBLANK(B1)
, then it will returnTRUE
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question