If calculations

[ClassyCleaning]

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?

 

[Pete_UK]

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]

That worked. Thanks.

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

 

[Pete_UK]

You're welcome.

Did I guess right?

Pete

That worked. Thanks.






- Show quoted text -