In cell E2, I would like a formula which will generate a "Y" if the item in
cell C2 is taxable, and a "N" if the item in cell C2 is not taxable .
The items that are not taxable in cell C2 is either "EVERGREEN", "METRO",
"RAILPOOL", or "SEACASTLE"; all other items are taxable.

Then, if there is a "Y" in E2, the formula in F2 would be "=(A2+B2)*1.07"
If there is "N" in E2, the formula in F2 would be just "=(A2+B2)"

Thanks for any assistance...