software

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.
--
Gary's Studentquot;B.W.quot; wrote:

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

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 quot;Squot; in the B
(Tax Code) Column w/o quotes)
A2 B2
Tax2 .025 or 2.5% (say this is for fed tax, use a quot;Fquot; in the B
(Tax Code) Column w/o quotes)
A3 B3
Tax3 .075 or 7.5% (Use quot;Bquot; 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=quot;Squot;,SUM(C6,(C6*$B$1)),IF(B6=quot;Fquot;,SUM(C6,(C6* $B$2)),IF(B6=quot;Bquot;,SUM(C6,(C6*$B$3)),C6)))--

Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) lt;message rulegt;
lt;lt;Previous Text Snipped to Save Bandwidth When Appropriategt;gt;quot;Gary''s Studentquot; gt; wrote in message
...
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.
--
Gary's Studentquot;B.W.quot; wrote:

gt; I have 4 columns, A1-item, B1-tax, C1-tax, D1- Total. Some items are
gt; taxable
gt; on both, others only on 1, is there a way to automatically charge 1 or 2
gt; taxes on the total.
gt; Thank-You
gt; B.W.What condition decides to choose B1-tax and C1-tax?

quot;B.W.quot; wrote:

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