E2: =if(or(c2="evergreen",c2="metro",c2="railpool",c2= "seacastle"),"Y","N")
F2: =(a2+b2)*(1+if(e2="y",.07,0))

Suggestion:
Instead of the long If statement in E2, use a lookup table. Then when your
products change, or the tax rate changes, you don't have to change any
formulas. Checkout Vlookup in Help.

Regards,
Fred.

"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...