To indicate a cell is empty, simply use quotes with nothing in between them
(not even a space). For example: =if(A1="","","Not Empty")

In this statement, I have stated that in cell A1, if it is empty it will
show empty, but if there is any value, it will state Not Empty. Let me know
if this helps you out.

"rmo5354 " wrote:

I need help writing an IF expression:
IF("reference cell is empty", leave blank, otherwise statement)

thanx


---
Message posted from http://www.ExcelForum.com/