I am looking for help setting up the following:

If Column 1 (drop-down menu called “Line”) is LABEL1, multiply Column 2, Column 3, 0.8,

If Column 1 is LABEL2, multiply Column 2, Column 3,

If Column 1 is LABEL3, multiply Column 2, Column 3, 0.6

It seems pretty straightforward (in my head), but I can’t get it to work.

IF({Line#Labels}=“LABEL1”,MULTIPLY({Column2},{Column3})),

IF({Line#Labels}=“LABEL2”,MULTIPLY(({Column2},{Column3}),0.80)),

IF({Line#Labels}=“LABEL3”,MULTIPLY({Column2},{Column3},0.6))

Any ideas would be appreciated!