ExcelBanter - keep cell blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - keep cell blank (https://www.excelbanter.com/excel-worksheet-functions/43638-keep-cell-blank.html)

Mary

keep cell blank

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

Duke Carey

=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

Max

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

All times are GMT +1. The time now is 11:27 AM.