Formula that looks for a word in a cell and multiplies a value

[PETRODATAjames]

I would like a formula that, sorry I will not write this correctly, but here goes. I need this formula to look for a specific word in column, B Product Types and if the word is Credits then multiply by .045, if the word is Food and Beverage then multiply by .050, if the word is Penalty Fees then multiply by .085, and so on. I also would need it, if the word is water, then blank, no multiple by, or multiply by 0, and not display an error, like #REF or something.

 

[PETRODATAjames]

Sorry, Fluff

I will post all my Excel questions, only here from now on. A long time ago I spent hundreds of dollars to Andy Pope on OzGrid, so I was going to stay with them. I will move here.