In E2:

=IF(OR(C2={"Evergreen","Metro","Railpool","Seacast le"}),"N",IF(C2="","","Y"))

In F2:

=(E2="N")*(A2+B2)+(E2="Y")*(A2+B2)*1.07
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Steve" wrote in message
m...
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...