Formula that multiplies value of one column based of value of other column

Hey peoples,

I have a question on how to make a formula that multiplies a value in a column based of a value in a different column. Let's take this data:

1 20
1 20
2 10
3 0
4 2
4 0
3 10

Left column are categories and right is scoring value. I want the scoring value to be multiplied based on their categories. The multipliers are as follows:
1 5x
2 1.5x
3 1.0x
4 0x

I have multiple columns of values and 1 column of categories. I want a total so a sum at the bottom of each column.
How do I make this formula?

The wanted result would be:
1 20
1 20
2 10
3 0
4 2
4 0
3 10
total 225

Welcome to the forum.

Please update your forum profile with the correct version (MS365 - what you have given is merely a release number).

Various ways ...

There are instructions at the top of the page explaining how to attach your sample workbook.