How do I reference an empty cell in a formula?
"Vasant Nanavati" wrote:
=IF(C2="",C1,C2)
if I understand you correctly.
__________________________________________________ _________________________
"srosebed" wrote in message
...
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.
|