copy command within a formula

[copy commad in excel formula]

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

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

 

[Max]

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

 

[ShaneDevenshire]

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.

 

[Dave Curtis]

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