Formula formatting needed --Please help
Posted by scott on October 11, 2001 1:15 PM
I don't understand excel very well and need help! I want to put my customers names, addresses, state, zip code, e-mail address, product, account receivable, sales tax, accrecbletaxed, amount paid ectera into excel. I have figured out how to make the columns using excel. What I am trying to do is when someone orders in my state, I have to charge them sales tax. I need a formula that when I put the state abreviation, like CA into the state column, it automatically multiplies the accounts receivable amount by the .0575 and then adds that amount into the next column(accrecbletaxed).
I hope I have made myself clear.
Any help would be appreciated--even a name of a good book that would help me understand what I am actually doing:).