Results 1 to 2 of 2

Thread: Help with a range of cells

  1. #1
    Join Date
    Feb 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry Help with a range of cells

    1) Help with a range of cells


    3) Describe problem:

    I have a range of numbers from 21900,19500,17700,17400,16800,15900. My challenge is to reduce these numbers proportionately so that the highest (21,900) becomes 1000 while the lowest (15,900) is 500? How can i do that in exel?

  2. #2
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    This is not the usual type of question we get here. Is this for a homework assignment?


    Edit: by the way, this can be done using some fairly simple algebra based on the MAX() and MIN() of that range.


    Edit 2: I was bored--
    =(((A1-MIN(A1:A5))/(MAX(A1:A5)-MIN(A1:A5)))*500)+500

    The range is for cells A1 through A5-- change as needed.
    The red A1 must be updated for every cell you're using as an input-- I'm assuming you're copying these to B1, B2, etc.
    Be careful NOT to update the other values (as might automatically happen if you use the 'dragging' option in Excel to copy the formula to other cells). Just that one instance of "A1".

    (And I'll just hope this isn't a homework assignment.)
    Last edited by djr33; 02-05-2013 at 08:39 PM.
    Daniel - Freelance Web Design | <?php?> | <html>| español | Deutsch | italiano | português | català | un peu de français | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

Similar Threads

  1. IP Address/Range/Mask?
    By bluewalrus in forum Other
    Replies: 1
    Last Post: 12-31-2009, 07:46 PM
  2. Replies: 0
    Last Post: 08-15-2009, 01:54 AM
  3. Range selectNode
    By j0n0 in forum JavaScript
    Replies: 0
    Last Post: 10-02-2008, 02:31 PM
  4. Selecting a time range
    By Grant Holmes in forum PHP
    Replies: 1
    Last Post: 01-03-2008, 09:12 PM
  5. Replies: 2
    Last Post: 08-18-2007, 10:20 AM

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
  •