Thread: keep cell blank
View Single Post
  #1   Report Post  
Mary
 
Posts: n/a
Default 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