Math Formula Expression

[kmarrs901]

I am struggling with writing a Math Formula to update Cells in multiple columns. I am trying to use the Math Formula (Multi-Column) to use an if statement that says if the value is below 100, multiply the value by 2080 (essentially converting an hourly salary into an annual salary. Any suggestions on how to write that expression?

In the image below for example, I need to multiply 21.5 by 2080.

[marzukim]

hi kmarrs901
does this meet with your expectations, in my example:
if $avg$ < 100 multiply by 2 else 10.
syntax:
if($avg$< 100,$$CURRENT_COLUMN$$ * 2,$$CURRENT_COLUMN$$ * 10)

rgds
linux knime 5.1.x

[kmarrs901]

@marzukim

if($avg$< 100,$$CURRENT_COLUMN$$ * 2,$$CURRENT_COLUMN$$ * 10)

Thank you. That worked nicely. My final formula was: if($$CURRENT_COLUMN$$< 100,$$CURRENT_COLUMN$$ * 2080,$$CURRENT_COLUMN$$ * 1)

Thanks again.