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 |
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) |