I'm using pi datalink on excel and want to reference another cell in a expression.

For example I want the expression ('A2' = 99), where A2 is a reference to the cell A2.

I'm using pi datalink on excel and want to reference another cell in a expression.

For example I want the expression ('A2' = 99), where A2 is a reference to the cell A2.

Hi Felix,

Thanks for posting on PI Square. Apologies, I'm still confused by your request.

Are you trying to construct an expression for a Datalink function using a cell reference? If I were to guess, you are trying to a performance equation to be used in a Datalink function.

If we assume that A2 is the Tag Name like sinusoid, the your cell syntax should look like: "(' " & A2 & " ' = 99)"

Again, this is all dependent on what you are after. If you can please provide some screenshots so that I understand what you are working with.

~Jesse

Hi Jesse,

Thanks for the reply.

A2 is suppose to be a reference to the cell. So for example is cell A2 I have \\AFSRV1\Production in the cell. And I want to make an expression in another cell referring to the A2 cell. So for example ("A2" = "OPEN"), so I can use this expression in one of the pi datalink function. Hope that makes sense, sorry for the confusion.

Felix

Hi Felix,

Gotcha, you are trying to create the PI Expression. Give this syntax a shot:

="('" & A2 & "'=""Open"")"

It's super hard to see on my answer so I added some spacing to make it easer to read:

="(' " & A2 & " ' =" " Open " ") "

Please give that a shot

~Jesse