In Colum "A" I have sub totals and I would need to find the GST and QST, I s
there any formula that will do it for you or would I have to do each sub
total manually and with a calculator

Hi,

The GST and QST are Canadian taxes I presume? I don't know anything about
the Canadian tax system since I am not Canadian, but one might use a VLOOKUP
formula or a custom VBA function.

To help you we need more info, or at least I do. Please explain how these
taxes are calculated.

--
Thanks,
Shane Devenshire


"music icons" wrote:

In Colum "A" I have sub totals and I would need to find the GST and QST, I s
there any formula that will do it for you or would I have to do each sub
total manually and with a calculator

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

"ShaneDevenshire" wrote:

Hi,

The GST and QST are Canadian taxes I presume? I don't know anything about
the Canadian tax system since I am not Canadian, but one might use a VLOOKUP
formula or a custom VBA function.

To help you we need more info, or at least I do. Please explain how these
taxes are calculated.

--
Thanks,
Shane Devenshire


"music icons" wrote:

In Colum "A" I have sub totals and I would need to find the GST and QST, I s
there any formula that will do it for you or would I have to do each sub
total manually and with a calculator

Assuming:
A11: holds sub totals
B12: holds GST tax
B13: hods QST tax

=A11*(1+B12+B13)


music icons" wrote:

In Colum "A" I have sub totals and I would need to find the GST and QST, I s
there any formula that will do it for you or would I have to do each sub
total manually and with a calculator