Multiple Nested If Function

[Sher10]

I now this should be really simple.

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

Your assistance is greatly appreicated

 

[Claus Busch]

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

 

[Don Guillett]

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.

If you REALLY REALLY WANT TO BE SURE

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

 

[Claus Busch]

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

 

[Don Guillett]

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.

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

 

[Sher10]

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

 

[Claus Busch]

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