+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Minimum Taxes Calculation Worksheet

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    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!!!
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,529

    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. #3
    Registered User
    Join Date
    01-12-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    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. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,529

    Re: Minimum Taxes Calculation Worksheet

    Perhaps you want separate calcs ?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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