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

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


"Mary" wrote:

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

One way:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mary" wrote in message
...
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