leave cells blank #2
 

I would like nothing to display when there is no data in the linked cell.
Here is my formula==IF(AND(J5="F",L5="F")=TRUE,"CBCCEDP-FED","CBCCEDP-State") CBCCEDP-State is always showing. If no data is
entered in the cell I5 how do I keep this cell's formula blank. Thanks in
advance, Mary

What's wrong about the answers to your previous identical query?

Regards,
KL


"Mary" wrote in message
...
I would like nothing to display when there is no data in the linked cell.
Here is my
formula==IF(AND(J5="F",L5="F")=TRUE,"CBCCEDP-FED","CBCCEDP-State")
CBCCEDP-State is always showing. If no data is
entered in the cell I5 how do I keep this cell's formula blank. Thanks in
advance, Mary

Did you look at what KL replied you on the other post? These 2 cases
are identical.


KL Wrote:
What's wrong about the answers to your previous identical query?

Regards,
KL


"Mary" wrote in message
...
I would like nothing to display when there is no data in the linked
cell.
Here is my
formula==IF(AND(J5="F",L5="F")=TRUE,"CBCCEDP-FED","CBCCEDP-State")
CBCCEDP-State is always showing. If no data is
entered in the cell I5 how do I keep this cell's formula blank.
Thanks in
advance, Mary


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=401315