Hi,

Just lose the quote marks

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

VBA Noob