D
Derek
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
example
M3=A2(if A1 has data)
do i need a macro for this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi
in m2 enter...
=if(A1="","",A2)
regards
FSt1
in m2 enter...
=if(A1="","",A2)
regards
FSt1
J
JLatham
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,"")
=IF(A1<>0,A2,0) or =IF(A1<>0,A2,"")
and if A1 is text
=IF(A1<>"",A2,0) or =IF(A1<>"",A2,"")
J
Joe User
JLatham said: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 -----
J
JLatham
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.
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.