Results 1 to 6 of 6

Calculate groupings

Threaded View

cmf0106 Calculate groupings 11-10-2009, 09:55 AM
SamuelT Re: Having excel calculate... 11-10-2009, 10:17 AM
martindwilson Re: Having excel calculate... 11-10-2009, 11:20 AM
cmf0106 Re: Having excel calculate... 11-10-2009, 12:34 PM
cmf0106 Re: Having excel calculate... 11-10-2009, 02:27 PM
martindwilson Re: Calculate groupings 11-10-2009, 12:55 PM
  1. #1
    Forum Contributor
    Join Date
    09-02-2009
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    110

    Calculate groupings

    In the file attached it lists numerous neighborhoods and their price range. I would like excel to automatically figure out which price range group a neighborhood falls in.

    Using the following price range breaks 0-139$ 140-174$ 175-224$ 225-274$ 275-324$ 325-374$ 375-424$ 425$+

    Again, I would like excel to automatically look at the min-max price for the neighborhood and determine which of the price range breaks the neighborhood falls under.

    For example hypothetical neighborhood A has a price range of 129-134$, that would categorize it within the 0-139$ break as stated above, I would like excel to then automatically write the price break group it belongs too for that neighborhood in the "price range" column.
    Attached Files Attached Files

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