Replicate Excel IF formula in KNIME

[fostc80857]

Hi

How would I re-create the following Excel formula in KNIME:

=IF(ISNA(AQ20),IF(ISNA(AS20),“”,AT20),AR20)

Thanks
Chris

[ipazin]

Hello @fostc80857,

you can use Rule Engine node or Column Expressions node. See here for more:

if then else with multiple conditions

Hello @sgknime, and welcome to KNIME Community! For Rule Engine if else logic see here: For Column Expressions if else logic see here: For Math Formula if else logic see here: In your case I would go with Rule Engine Br, Ivan

Br,
Ivan