SWITCH Formula to calculate costs with variables from multiple columns

I have a Printing Project board that has many columns populated from a dynamic form. Part of the board needs to have pricing. I have been exploring SWITCH and keep getting a red exclamation mark. The way it should work is: Column “Weight Cost” This calculation should be : If PAPER WEIGHT is 65 LB (CARD) multiply the PAPER COST by a factor of 1.8.

Please help.



The next piece of this would be if an order is 65 LB (CARD) and COLORED PAPER. After the card calculation, IF the PAPER COLOR is YELLOW, multiply by a factor of 1.2.

All of these would then be totaled in a PRINT COST column.

I really appreciate the help.