I now this should be really simple.

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"

Your assistance is greatly appreicated.

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

On Friday, September 14, 2012 6:56:27 AM UTC-5, Sher10 wrote:
I now this should be really simple.



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"



Your assistance is greatly appreicated.









--

Sher10

If you REALLY REALLY WANT TO BE SURE

=IF(LEN(TRIM(G7))+LEN(TRIM(G8))+LEN(TRIM(I7))+LEN( TRIM(I8))<4,"n","y")

Hi Don,

Am Fri, 14 Sep 2012 07:43:31 -0700 (PDT) schrieb Don Guillett:

If you REALLY REALLY WANT TO BE SURE

=IF(LEN(TRIM(G7))+LEN(TRIM(G8))+LEN(TRIM(I7))+LEN( TRIM(I8))<4,"n","y")

not really sure. What happens, if in G7 are 4 or more characters


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

On Friday, September 14, 2012 6:56:27 AM UTC-5, Sher10 wrote:
I now this should be really simple.



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"



Your assistance is greatly appreicated.









--

Sher10

Good catch. It is Firday.....sp
change + to OR
or(len, len,len,len<0

Thank oyu, this worked well, tough I changed it to a countblank function.
Thank you for your prompt reply.

Hi,

Am Sat, 15 Sep 2012 01:48:32 +0000 schrieb Sher10:

Thank oyu, this worked well, tough I changed it to a countblank
function.

but if there is a space in one of the cells, the cell will not be count
as blank.
Try:
=IF(MIN(LEN(TRIM(G37:G38)),LEN(TRIM(I37:I38)))=0," Sheet not
complete","Sheet completed")
Array formula to enter with CTRL+Shift+Enter


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