copy if
 

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

copy if
 

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

copy if
 

hi
in m2 enter...
=if(A1="","",A2)

regards
FSt1

"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

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

copy if
 

No argument with the <0 issue - the data itself could be zero. As for the
other, I like to do it that way when I'm explicitly looking for text entries
in a cell, although might even consider using ISBLANK() but we don't know
that the cell to be tested has a formula or not.

"Joe User" wrote:

"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

.