And function?

[banker123]

I need to do the following:

-I first need to determine if column A is greater than 0

-If it is then I need to bring back "Yes" if column A's contents match the contents of column C

I think I probably need an AND fucntion but I have never used one before. Any help is appreciated.

[Special-K]

=IF(AND(A1>0,A1=C1),"Yes","No")

[banker123]

Worked perfectly, thanks!