trying to figure out how to get a total in one cell depending on a word I enter in another

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!

Assuming your number (that you want multiplied) is in column A, and the Disposal 1 (or Disposal 2) is in column D, then you can use this formula (e.g. in F2):

=A2 * IF(D2="Disposal 1",100,IF(D2="Disposal 2",125,0))

then copy down.

Hope this helps.

Pete

YES! It works! You're so awesome! Thanks a bunch.

Glad to hear it.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete