| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Linear Mode
