C
clk
Hi. I need to have one cell in my summary spreadsheet that looks to
another detail spreadsheet and gives me the data if there is something
in the cell. I have it working for one but when I try to nest the "if
then else" statement it fails.
Basically what I have is this:
=IF('May 19'!K4="", "","Vac") Now I need to add to this if K5 is not
null "sick", k6 is not null "personal", etc.
It will work for one with the above formula but when I try adding more
criteria it fails. I tried this:
=IF(('May 19'!$K4=""),"",IF(('May 19'!$K5=""),"",IF(('May 19'!
$K6=""),"",IF(('May 19'!$K7=""),"",CONCATENATE(K4,K5,K6,K7,K8)))))
But that didn't work either.
Any suggestions would be appreciated.
another detail spreadsheet and gives me the data if there is something
in the cell. I have it working for one but when I try to nest the "if
then else" statement it fails.
Basically what I have is this:
=IF('May 19'!K4="", "","Vac") Now I need to add to this if K5 is not
null "sick", k6 is not null "personal", etc.
It will work for one with the above formula but when I try adding more
criteria it fails. I tried this:
=IF(('May 19'!$K4=""),"",IF(('May 19'!$K5=""),"",IF(('May 19'!
$K6=""),"",IF(('May 19'!$K7=""),"",CONCATENATE(K4,K5,K6,K7,K8)))))
But that didn't work either.
Any suggestions would be appreciated.