Formula to say "yes" if Column I has text, to say "no" if column I is blank

[Shrad013]

What formula can I use for a column to generate "yes" if Column [I] has text, and to generate "no" if column [I] is blank

[jeffreybrown]

Maybe...

=IF(ISTEXT(I1),"yes",IF(ISBLANK(I1),"no",""))

[Shrad013]

Thanks Jeff. It works for blank, but The formula produces no "yes" for I. Column I is filled with Dates. Would that change the formula?

[Winon]

Hello Shrad013,

Or if you want to check for any Data in Cell I, Text or Integer, you could use;

=IF(I1<>"","Yes","No")

[Shrad013]

Winon,

Can you adjust your formula so that cells also remain blank if column [A] is blank?

[Winon]

Yes,

=IF(A1="","",IF(I1<>"","Yes","No"))

It all depends on your exact requirements and/or conditions.