Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy command within a formula
Is this formula a valid one. Is there another way of doing this?
If(c6=201,copy c7,"") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy command within a formula
The equivalent is to return it into a cell,
say, in D6: =IF(C6=201,C7,"") And then you can take it up further from there -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- "copy commad in excel formula" wrote: Is this formula a valid one. Is there another way of doing this? If(c6=201,copy c7,"") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy command within a formula
Hi,
Let me address your first question - no, you can't put a command into a function. Function return results of calculations to cells, they can't make any actions that affect the user interface. -- Thanks, Shane Devenshire "copy commad in excel formula" wrote: Is this formula a valid one. Is there another way of doing this? If(c6=201,copy c7,"") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy command within a formula
Hi,
No, that isn't valid. What are you trying to achieve? Try =If(c6=201,c7,"") Dave url:http://www.ureader.com/msg/104240168.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Command | Excel Discussion (Misc queries) | |||
Copy Hyperlink command | Excel Discussion (Misc queries) | |||
Automate copy command? | Excel Worksheet Functions | |||
Automate copy command | Excel Discussion (Misc queries) | |||
how do i enter data using formula and the Copy command For exa. | New Users to Excel |