+ Reply to Thread
Results 1 to 4 of 4

Normalization

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Normalization

    Hello,
    I have an excel work sheet with huge data in it.(138 columns and 7070 rows).

    I am trying to apply a rule on every cell.

    The rule is :-

    1) If the value in the cell is than 20, then make the value of that cell as 20.
    2) if the value in the cell is greater than 16000 then make the value of that cell as 16000.

    When I tried using the IF condition, I am unable to define the logic for the else part,( As it is either 0 or nothing.)

    Any help is greatly appreciated.


    Regards,
    Chaitanya

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Normalization

    Hi and welcome to the board

    Is the value the result of a formula? If so, which formula is it ?

  3. #3
    Registered User
    Join Date
    12-07-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Normalization

    Hello,
    There is no predefined formula.
    I am trying to write something like this .
    if (cell value <20)
    cell value = 20
    elseif(cell value >16000
    cell value = 1600
    end if
    end if
    i know the logic, but dont know how to implement in excel.

    Thanks in advance!

    Chaitanya

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Normalization

    Maybe =MEDIAN(A1, 12, 16000)
    Entia non sunt multiplicanda sine necessitate

+ 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