I was told that Excel can use word formulas. Is this true? I have one
worksheet that has our proposals which adds up the sums of different cells.
I need to create an easy way for my salesmen to include sales tax. Seems
pretty basic, but not every city has the same tax rate and the salesman can't
seem to be able to figure out how to coss refernce the information to plug
in. I had an idea of creating a different worksheet that lists the different
cities and rates, but how can I get that information to pull into thier
proposal by just having them type in the city? Then I could create a cell
that will multiply the tax rate of that city by the subtotal for the total.
Any ideas if excel can do this?