View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default Charging 1 or 2 Taxes on items automatically

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 Student


"B.W." wrote:

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.