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.
|