the if statement is if(criteria, true do this, false do this) you put
your
In your and statement it will work out exactly as you said as any non
blank cell will cause and to be false.
try
=IF(OR(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1),ISBLANK (D1)),"
","POPULATED")
This will work out if any cell is blank, if any cell is blank the data
is not populated and returns " " otherwise all the cells are populated
and 'Populated'
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=516825