I need to calculate sales tax from two states with different sales taxes. I
want to designate one cell with a T or N and then have my invoice calculate
the sales tax pertaning to that state depending on what that cell has in it.
How do I build this formula?

Something like:

=IF(A1="T",6.5%,IF(A1="N",5%,0))

where A1 contains T or N (and I've guessed the tax rates).

Hope this helps.

Pete

"ClassyCleaning" wrote in message
...
I need to calculate sales tax from two states with different sales taxes. I
want to designate one cell with a T or N and then have my invoice
calculate
the sales tax pertaning to that state depending on what that cell has in
it.
How do I build this formula?

That worked. Thanks.

"Pete_UK" wrote:

Something like:

=IF(A1="T",6.5%,IF(A1="N",5%,0))

where A1 contains T or N (and I've guessed the tax rates).

Hope this helps.

Pete

"ClassyCleaning" wrote in message
...
I need to calculate sales tax from two states with different sales taxes. I
want to designate one cell with a T or N and then have my invoice
calculate
the sales tax pertaning to that state depending on what that cell has in
it.
How do I build this formula?

You're welcome.

Did I guess right?

Pete

On Jul 10, 10:15*pm, ClassyCleaning
wrote:
That worked. Thanks.



"Pete_UK" wrote:
Something like:

=IF(A1="T",6.5%,IF(A1="N",5%,0))

where A1 contains T or N (and I've guessed the tax rates).

Hope this helps.

Pete

"ClassyCleaning" wrote in message
...
I need to calculate sales tax from two states with different sales taxes. I
want to designate one cell with a T or N and then have my invoice
calculate
the sales tax pertaning to that state depending on what that cell has in
it.
How do I build this formula?- Hide quoted text -

- Show quoted text -