help with formula

DR, Bob · Nov 12, 2004

I need a formula to do this l A1 will = A2 only if A3 is greater then 0.
( if A3 is 0 then A1 will not = A2)

Frank Kabel · Nov 12, 2004

Hi
try in A1
=IF(A3>0,A2,"")

DR, Bob · Nov 12, 2004

thanks worked great...

Frank Kabel said:
Hi
try in A1
=IF(A3>0,A2,"")