music icons;
If this is a tax as ShaneDevenshire suggests, place the price of the
item/service in column A. Sum the items and/or services as appropriate (by
gst/qst or whatever). Place the subtotals in a cell (b4 and b5 for example).
Place the appropriate tax rate in cell c4 and c5 respectively(example).
In cell c6 enter
=sum((c4*sum of services),(c5*sum of products))
something like that. It's no different that calculating tax in america if it
is a straight forward tax (Yeah, right. Like any tax is straight forward(read
'reasonable)').
Anyway, ShaneDevenshire is very observant regarding an array in that if your
tax is scaled somehow, it will be much easier to do a lookup() than to try to
create complex calculations that refer to a cell, to a cell, to a cell, to a
if(), to a cell, etc.
God Bless
Frank Pytel
