expression as string in if clause

[Sergio3]

Hi, mates.

Help me.

How to put expression as string in if clause?

For example:

IF(vTEST=0, SUM(x),0)

Expression in chart:

SUM(Y)+$(vTEST) 

vTEST need to be like 'SUM(x)', like SET in script.

Thanks!

[gf]

Hello Sergio,

I would use two variables.

vTest and vTest2.

vTest is your number and in vTest2 you check vTest with  =IF(vTest=0,Sum(x),0)

Then you can calculate with vTest2 like  =Sum(y)+$(vTest2)

Regards,

gf

[gf · Accepted solution]

Have a look at this simple program for better understanding.

[Sergio3]

Thank u sir!