Function IF excel to Spotfire

[Francisco Aspillaga]

Hi All,

How would you write these two "IF" functions from excel to spotfire?

1) =if(A1=""";B1;C1"). function so that cell A1 is a blank value copy to the value of cell B1, otherwise copy the value of C1).

2) =if(A="";"";if(A>=0.8;"High";IF(A<=0.5;"Low";"Medium")))

[Fredrik Rosell]

Hello,

I would write 1 as

If([A] Is Null,,[C])

For 2, that could be written as several nested "If" statements, but I think it becomes more readable using "Case" instead:

Case 

when [A] is Null then "" 

when [A] >= 0.8 then "High" 

when [A] <= 0.5 then "Low"

else "Medium" 

end