Automatically add text to cell if blank

[SaraWitch]

Hello peeps,

I would like to automatically add the text "Target met" to a cell if it is blank (C1) and if a previous cell contains data (A1).

I have tried several ways, but nothing is working (I am usually ending up with a circular reference, even with a helper column because C1 is not technically blank as it contains the formula to return the text!).

Latest I've tried:

In the helper column (D):

=IF(AND(A1<>"", C1=""), "Target met", C1)

In the column I want the autotext if blank (C):

=IF(D1="Target met", "Target met", "")

Any suggestions?

 

[SaraWitch]

Correction!

=IF(A1<>"",IF(B1>=25,"Target met",""))

 

[smozgur]

Correction!

=IF(A1<>"",IF(B1>=25,"Target met",""))

Thanks for posting your solution!

 

[SaraWitch]

Update! To remove FALSE results:

=IF(A1<>"",IF(B1<=25,"Target met",""),"")