PETRODATAjames
New Member
- Joined
- Aug 20, 2022
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
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.