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
|