Charging 1 or 2 Taxes on items automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are taxable
on both, others only on 1, is there a way to automatically charge 1 or 2
taxes on the total.
Thank-You
B.W.
 
It is easy:

set the values in columns B and C as percents. Then D would have something
like:
=(1+B1+C1)*A1

With this set-up you can remove a column B or C tax just by setting the
value to zero.
 
B.W,
You can also add an additional column to indicate how the Item is taxed.
Say you set-up the sheet like this:
A1 B1
Tax1 .05 or 5% (say this is for state tax, use a "S" in the B
(Tax Code) Column w/o quotes)
A2 B2
Tax2 .025 or 2.5% (say this is for fed tax, use a "F" in the B
(Tax Code) Column w/o quotes)
A3 B3
Tax3 .075 or 7.5% (Use "B" in the B (Tax Code) Column w/o quotes,
if you need to tax at both rates)

Starting in Row 5 create your Title table:
A5 B5 C5 D5
Item Tax Cost Total
Name Code

In Cell D6 put the following formula in it, and fill down:
=IF(B6="S",SUM(C6,(C6*$B$1)),IF(B6="F",SUM(C6,(C6*$B$2)),IF(B6="B",SUM(C6,(C6*$B$3)),C6)))


--

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


It is easy:

set the values in columns B and C as percents. Then D would have something
like:
=(1+B1+C1)*A1

With this set-up you can remove a column B or C tax just by setting the
value to zero.
 
Back
Top