Change formula based upon value of a different cell
You could put this in E2:
=IF(C2="","",IF(OR(C2="Evergreen",C2="Metro",C2="R ailpool",C2="Seacastle"),"N","Y"))
to return Y or N as appropriate as long as C2 is not empty. Put this
one in F2:
=IF(E2="","",IF(E2="Y",(A2+B2)*1.07,A2+B2))
You will again get a blank returned if E2 (and thus C2) is blank,
otherwise your calculated values.
Hope this helps.
Pete
On Aug 29, 11:22*pm, "Steve" wrote:
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...
|