IF THEN statement

Geoff Baker

Still struggling with IF THEN :(

Any help would be appreciated.

IF HIERARCHY = 1 or 2 THEN ([ORDER QTY]@row * [UNIT WEIGHT KGS]@row)

THANKS!

James Keuning

IF(OR(HIERARCHY@row=1,HIERARCHY@row=2),([ORDER QTY]@row * [UNIT WEIGHT KGS]@row))

James Keuning

IF(OR(HIERARCHY@row=1,HIERARCHY@row=2),([ORDER QTY]@row * [UNIT WEIGHT KGS]@row))

Geoff Baker

James THANK YOU it works perfectly!