Logical arguments and linking

P

patsy

I am trying to link cells from a shared worksheet to my spreadsheet. I got
the linking down but I want to use a logical argument. In other words, if
the value of column A on the shared worksheet is greater than SHAW000, then I
want that cell to link to my spreadsheet. If the value is not greated than
SHAW000 than don't link it. Can anyone help with this? Thanks.
 
T

Tyro

What do you mean by "link"? You can use an IF statement.
IF(test_condition,true,false). Nothing unusual here.

Tyro
 
P

patsy

I am linking a cell from a shared worksheet to my worksheet and I only want
my information to link. All these cells that I will enter will start with
SHAW. Those are the only entries that I want linked to my own worksheet. If
the cell starts with anything other than SHAW, I don't want it to link. Hope
this explains what I am looking for.
 
Top