How do I reference an empty cell in a formula?

[srosebed]

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.

 

[Toppers]

=if(ISBLANK(A2),A1,A2)

 

[Vasant Nanavati]

=IF(C2="",C1,C2)

if I understand you correctly.
___________________________________________________________________________

 

[Peo Sjoblom]

It depends, would the cell be the next cell above?

=IF(A5="",A4,A5)

 

[srosebed]

That's it!! Thanks a million.

=if(ISBLANK(A2),A1,A2)

 

[srosebed]

Thanks!

It depends, would the cell be the next cell above?

=IF(A5="",A4,A5)

 

[srosebed]

Thanks! for another approach.

=IF(C2="",C1,C2)

if I understand you correctly.
___________________________________________________________________________

 

[remove dupplicate entry]

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.

 

[remove dupplicate entry]

=IF(C2="",C1,C2)

if I understand you correctly.
___________________________________________________________________________

 

[remove dupplicate entry]

That's it!! Thanks a million.