I have the following formula in place.

```
=TRIM(
IFERROR(IF(AND($T9-TODAY()>=Key!$N$14,$T9-TODAY()<=Key!$M$14,$AA9<>"Complete",$G9<>"New Phase",$T9<>""),Key!$L$11,""),"Error")
)

```

I was noticing that the "Error" part of the `IFERROR` was running. So after reviewing my formula, I was pretty certain the reason was that column T was empty sometimes. So I put the following check into place `$T9<>""`. However, since adding this, the "Error" is still showing.

Shouldn't my added condition result in the "FALSE" part of the condition running? Which is just "".

Does anyone have any insight?

[![enter image description here](https://i.stack.imgur.com/kYMz7.png)](https://i.stack.imgur.com/kYMz7.png)

[![enter image description here](https://i.stack.imgur.com/HZJsB.png)](https://i.stack.imgur.com/HZJsB.png)