Conditional statements in Field Calculator QGIS

Question

Is it possible to modify the following syntax somehow that it would be applicable in Field Calculator in QGIS? The input layer is point layer and I would like to do following calculations which I can't do in Excel due to large amount of data.

if(  "VALUE1" < 0.01, 2,
  if( AND( "VALUE1" >= 0.01, "VALUE1" < 0.1 ), 3,
    if( OR( "VALUE1" >= 0.1, "VALUE2"  >= 2 ),  4, 0 )
  )
)

Any ideas?

Answer 1

You can use the CASE WHEN statement. I will give you an example, adapt it.

CASE WHEN  "VALUE1" < 0.01 THEN 2
WHEN "VALUE1" >= 0.01 AND "VALUE1" < 0.1 THEN 3 
ELSE 4
END 

I applied this formula to the VALUE2 field, here is the result:

Answer 2

Just offset the logical operators and petr's syntax is right (imho)

if("VALUE1"<0.01,2,if("VALUE1">=0.01 AND "VALUE1"<0.1,3,if("VALUE1" >=0.1 OR "VALUE2">=2,4,0)))