SWITCH Formula to calculate costs with variables from multiple columns

Platform discussions
,
1

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.

Thanks

Steve

2

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.