copy if
in [General]
|
Prev: how do I delete documents from the start list in word and excel?
Next: How to change default date formula on Excel worksheet
From: Derek on 17 Apr 2010 18:22 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
From: JLatham on 17 Apr 2010 19:01 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
From: FSt1 on 17 Apr 2010 19:01 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
From: Joe User on 17 Apr 2010 19:17 "JLatham" <JLatham(a)discussions.microsoft.com> 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" <JLatham(a)discussions.microsoft.com> wrote in message news:98FCD28D-5322-4FCF-A391-6C35E8682841(a)microsoft.com... > 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
From: JLatham on 17 Apr 2010 20:58
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" <JLatham(a)discussions.microsoft.com> 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" <JLatham(a)discussions.microsoft.com> wrote in message > news:98FCD28D-5322-4FCF-A391-6C35E8682841(a)microsoft.com... > > 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 > > . > |