Hi,

Am Fri, 14 Sep 2012 11:56:27 +0000 schrieb Sher10:

I have 4 cells G37, G38, I37, I38. Now if any of these cells are left
blank I want a message to read in Cell A1 "Spreadsheet not complete" if
all cells are completed with a figure then "Spreadsheet completed"

try:
=IF(COUNTA(G37:I38)<4,"Spreadsheet not complete","Spreadsheet completed")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2