IF statement, how to dispaly "Yes" "No"

[Editz]

I am using this formula to find out if a cell in col G is in Col A.

=COUNTIF(G:G,A6)

At the moment is is displaying a 1 or a 0

Can I make it display text such as Yes No?

Thanks.

[sweep]

Hi,

=IF(COUNTIF(G:G,A6)>0,"Yes","No")

should do it

hth

dave

[Editz]

Thank you.