Hello I am looking for help writing an IF Then Formula. I am putting together a 3D Printing Cost Recording Sheet. Basically what I want is to type the specific material in one column (such as PLA or ABS), type the weight of the material in another column, and have another column multiply the weight by the Unit weight (this unit weight will not be shown in the excel sheet). There will be 5 materials with 5 unique price per gram numbers. Can anyone help me with this?

Here is an example.
Material Weight Cost
PLA 23g (Need This) The price per gram for PLA is 0.0666/gram. The weight will end up being (23*0.0666). I need the formula to do this automatically for me when I type in PLA. If I were to type NYLON instead of
PLA, it should be (23*0.093).