Nested IF Function. Math Formula Node

Hi there I wonder if it might be possible to make a Nested IF function, with the Math Formula Node. I tried with a "code" with the logical function if(x,y,z) but I the output is an empty column.

if($A1$>1,"YES","NO" )

I want to obtain YES if the result is True and NO is the result is False.

On the other hand, I wonder how can I make a Nested IF function, done in Excel, of this kind (I am pasting the Excel Formula).



Thank you








The Math Formula node is meant for simple expressions only. If you have complex expression (such as nested ifs) then I suggest you use one of the Java Snippet nodes.

Other option might be the Rule Engine/Ruleset Editor (assuming you do not want computations in the result).