copy if
"JLatham" wrote:
if A1 is numeric:
=IF(A1<0,A2,0) or =IF(A1<0,A2,"")
And what if A1 "has data", but it is zero? Rhetorical question.
and if A1 is text
=IF(A1<"",A2,0) or =IF(A1<"",A2,"")
That is also the correct way to determine if A1 "has data" that is numeric.
----- original message -----
"JLatham" wrote in message
...
if A1 is numeric:
=IF(A1<0,A2,0) or =IF(A1<0,A2,"")
and if A1 is text
=IF(A1<"",A2,0) or =IF(A1<"",A2,"")
"Derek" wrote:
I want to copy data from one cell to another, but only if a 3rd cell has
data
example
M3=A2(if A1 has data)
do i need a macro for this
|