Multiple Conditional @IF Statement Not Working?

I am trying to filter and change column T via what is on same row in column Y, otherwise return T's original results.

In english: If T2 equals zero AND Y2 doesn't equal zero, ,then make a one, otherwise list the contents of the original cell T2.

Here is my formula: =IF(AND(T2="0",Y2<>"0"),"1",+T2)

Cell T2 = 0
Cell Y2 = 232

Formula returns 0, I had hoped it would return a 1? Thanks!

Hi,

Just lose the quote marks

=IF(AND(T2=0,Y2<>0),1,T2)

VBA Noob

Thanks Noob, that worked!