using a calculation in a list on another worksheet
 

I am trying to create a forumula that will auto-generate my Provincial
(State) and Federal Tax based on where my customer is.

I have five different tax regions (this will expand) and I have two
possible tax calculations per region.

I need the amount entered to calculate the tax based on the tax region;
coded 1-5

I have tried using a combination of IF and VLookup but my syntax just won't
gel.

Can anyone help?

Thanks

using a calculation in a list on another worksheet
 

Hi Tina, could you send us a sample of you formula?

regards from Brazil - going to the 6th
Marcelo



"TinaBrooks" escreveu:

I am trying to create a forumula that will auto-generate my Provincial
(State) and Federal Tax based on where my customer is.

I have five different tax regions (this will expand) and I have two
possible tax calculations per region.

I need the amount entered to calculate the tax based on the tax region;
coded 1-5

I have tried using a combination of IF and VLookup but my syntax just won't
gel.

Can anyone help?

Thanks

using a calculation in a list on another worksheet
 

Hi Marcelo,

Thanks for replying.

What I am currently using is this:

=IF(taxable="y",ROUND((Amount/(1.07*1.075))*0.07,2),0) This returns me my
GST calculation for Quebec. The PST calculation for Quebec is
=IF(taxable="y",ROUND(((Amount/(1.07*1.075))*1.07)*0.075,2),0)

I have two slightly different but similar tax calculations for 5 different
locales and expect that list to expand as our company grows.

The Locale list would return a list something like this...

Default, QST, PST
Ontario, QST, PST
BC, QST, PST
Nova_Scotia, QST, PST
Exempt, 0,0

you get the idea?

T


"Marcelo" wrote:

Hi Tina, could you send us a sample of you formula?

regards from Brazil - going to the 6th
Marcelo



"TinaBrooks" escreveu:

I am trying to create a forumula that will auto-generate my Provincial
(State) and Federal Tax based on where my customer is.

I have five different tax regions (this will expand) and I have two
possible tax calculations per region.

I need the amount entered to calculate the tax based on the tax region;
coded 1-5

I have tried using a combination of IF and VLookup but my syntax just won't
gel.

Can anyone help?

Thanks