=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
|