keep cell blank

M

Mary

Good morning,
I would like the cell with the following formula to remain blank when
nothing is entered in cell J5 or L5. Right now it is reading "CBCCEDP-STATE."
Here is the formula:
IF(AND(J5="F",L5="F")=TRUE,"CBCCEDP-FED","CBCCEDP-State")

Thank you in advance,
Mary
 
M

Max

One way:

=IF(OR(J5="",L5=""),"",IF(AND(J5="F",L5="F"),"CBCCEDP-FED","CBCCEDP-State"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top