Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Convert column of data values to natural log values

  1. #1
    Guest

    Default

    I am a novice at excel and have numerous data sets entered in excel in numerous different files and worksheets. I need to convert these columns of data values (some as large as 250 values in one column) to there ln value in order to run ln transformation statistics. I do not want to do this one at a time as I have a considerable amount of data values. How do I convert a whole column of data values into the ln equivalent, either in the original (same) column or having the formula give the ln into another column. Hope I made myself clear. Thanks for any and all help.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-25 14:28, Anonymous wrote:
    I am a novice at excel and have numerous data sets entered in excel in numerous different files and worksheets. I need to convert these columns of data values (some as large as 250 values in one column) to there ln value in order to run ln transformation statistics. I do not want to do this one at a time as I have a considerable amount of data values. How do I convert a whole column of data values into the ln equivalent, either in the original (same) column or having the formula give the ln into another column. Hope I made myself clear. Thanks for any and all help.
    Have a look at the LN worksheet function under Help.

    In B1 enter

    =LN(A1)

    in order to transform the numeric value in A1.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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