set a variable

[adiarnon]

hi,

i want to set a variable in the script that have-

if($(v_metric_5)<90,'red',if($(v_metric_5)<95,'yellow',if($(v_metric_5)<=100,'green','gray')))

how can i do that?

[petter]

Please do not cross-post (post the exact same question multiple times) as it is counter-productive. Read the Community guidelines and do your best to follow them

[rubenmarin]

Hi adi, one way is using an alternative character for simple quotes and dollars, and use replace to reset to original characters, ie. using | as simple quote and # as dollar:

LET VarName =Replace(Replace(

'if(#(v_metric_5)<90,|red|,if(#(v_metric_5)<95,|yellow|,if(#(v_metric_5)<=100,|green|,|gray|)))'

,'|',Chr(39)), '#', '$');

[dsharmaqv]

try this

=IF(v_metric_5<00,Red(),IF(v_metric_5<9510,Green(),IF(v_metric_5<=100,Blue())))