Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generating a report list and statistic worksheet in Excel from other workbooks | Excel Discussion (Misc queries) | |||
Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
Protecting a worksheet containing XML List | Excel Discussion (Misc queries) | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
List on different worksheet | Excel Discussion (Misc queries) |