Hello,

I created a spreadsheet that calculates trucking costs and disposal costs for my job. When I created it, we were only using one disposal company. Now, there are two and they have different prices. One column on my spreadsheet has the title "Disposal Used". If I type "Disposal 1" in a cell under that column, I need it to multiply by $100. If I type "Disposal 2" in that cell, I need it to multiply by $125. And my answer will go in another column that has the heading "Disposal Total". Any help would be greatly appreciated!