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

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


--
Regards,

Peo Sjoblom


"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.