copy command within a formula
 

Is this formula a valid one. Is there another way of doing this?

If(c6=201,copy c7,"")

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,"")

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,"")

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