If B1 equals 0 then c1 text reads....

[San Antonio Heat]

In Column A I have names, in Colum B I have it counting how many matching names on next page =COUNTIF(Sheet1!A1:C14,A1)
In column C, I would like it to give me text for the results I have, Example would be in C1 if B1 is a 1 then the text Signed Player appears, if B1 is a 0 the Free Agent appears, thx guys

 

[Big Monkey]

In Column A I have names, in Colum B I have it counting how many matching names on next page =COUNTIF(Sheet1!A1:C14,A1)
In column C, I would like it to give me text for the results I have, Example would be in C1 if B1 is a 1 then the text Signed Player appears, if B1 is a 0 the Free Agent appears, thx guys

How many different texts will you be using? What are the possible outcomes, just 1 or 0?

=if(b1=1, "Signed Players", "Free Agent")

 

[San Antonio Heat]

Awesome Big monkey, thanks! you nailed it

 

[barry houdini]

...or you could do it all in one formula with

=IF(COUNTIF(Sheet1!A1:C14,A1),"Signed Players","Free Agent")