How do I reference an empty cell in a formula?
"srosebed" wrote:
That's it!! Thanks a million.
"Toppers" wrote:
=if(ISBLANK(A2),A1,A2)
"srosebed" wrote:
Trying to write an IF statement to return one value if the cell is empty and
another if not. For example, if the cell is empty, return the value above,
if not empty, return the value itself.
|