Multiple Condition IF Statement

[knotty150]

Hi All

I'm struggling with trying to piece together IF/AND/OR into a single statement. Would someone be able to point me in the right direction with the following please:

IF "COLUMN 1" = "VALUE 1" OR "VALUE 2"
AND "COLUMN 2" = 0
THEN "COLUMN 3" - "COLUMN 4"
ELSE 0

Thanks All!

Rich

 

[Tianbas]

something like

=IF((Table5[Column1]="Value 1" || Table5[Column1]="Value 2") && Table5[Column2]=0,Table5[Column3]-Table5[Column4],0)