# Excel 2007 : Minimum Taxes Calculation Worksheet

1. ## Minimum Taxes Calculation Worksheet

I'm trying to compare a city (chosen from a drop-down) to a list of cities referenced on a separate sheet called 'CitiesMins' which shows the minimum tax required per city. The formula should then find the city and check the current calculation against the minimum and return the figure for the higher of the two fields.

The formula works fine when referencing an individual cell, but when I try to use a defined name range for multiple cells to check against, I get a #VALUE! error.

I've attached a copy of my spreadsheet to clarify. Any help would be greatly appreciated!!!

2. ## Re: Minimum Taxes Calculation Worksheet

Could you provide expected results for a few more cities ?

I can't work out if Counties takes precedence over Cities or vice versa...
moreover where no Min is listed (County) presumably this means no Min exists (same holds true of Cities not listed)

Regards the Cities - you should be working from the single contiguous data table (Cities)
Splitting the data into three tables (CitiesMin) is only going to complicate matters (and inefficiencies) to your final formula
(ie check table3, then table2 [if not in 3] then table1 [if neither in 3 nor 2])

3. ## Re: Minimum Taxes Calculation Worksheet

I was actually able to get the correct results by adding another lookup column to find the city minimum and then hid it. Then I made the field in the Applicable Tax column for the city take the higher of the Calculated Tax and hidden lookup.

Sometimes the most simple answer is the hardest one to see!

4. ## Re: Minimum Taxes Calculation Worksheet

Perhaps you want separate calcs ?

``Please Login or Register  to view this content.``

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1