I’m not great with formatting Monday formulas, but first attempt would look something like this:
SWITCH({Dropdown#Labels},“Label 1”, MULTIPLY({Numbers 1},{Numbers 2}),“Label 2”, MULTIPLY(({Numbers 1},{Numbers 2}),0.80),“Label 3”, MULTIPLY(({Numbers 1},{Numbers 2},0.60),“”)
Set up is, SWITCH({Column}, “variable1”, “result 1”, “variable2”, “result 2”,
Now the only kicker is that SWITCH may not be able to process additional formulas as “Results”. Maybe someone who is more knowledgeable about this can help as I may just take some format tweaking to get it right.
Another option for you might be the General Caster app. General Caster is here. Get rid of formula columns! You can do a lot more formula wise and it will be better for you down the road since the Formula Column in Monday often creates limitations when it doesn’t interact with other features. Here is a list of all the formula options you can use with General Caster, including IFS. Functions | Formula.js. IFS was my first thought for fixing this but Monday doesn’t support that currently.