D
D
dollar2021-02-03 05:27:25
Google Sheets
dollar, 2021-02-03 05:27:25

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

1 answer(s)
A
Alexander Ivanov, 2021-02-03
@dollar

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 C1add =ISBLANK(B1), then it will returnTRUE
601a2b7b23fc8863726221.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question