+ Reply to Thread
Results 1 to 2 of 2

Copying formulas in excel

  1. #1
    antonis
    Guest

    Copying formulas in excel

    I have the column A full with 252 entries. The formula I apply between cells
    A2 and A1 is:
    ln(A2/A1)
    and I get a result.
    I want to copy this formula but in a way that the Excel itself to perform
    the following calculation:
    ln(A3/A2)
    ln(A4/A4)
    ln(A5/A4)
    etc.
    I would be pleased if someone could tell me if I can achieve that.
    --
    antonis

  2. #2
    Registered User
    Join Date
    07-25-2005
    Posts
    62
    Click on the first cell with a formula in it. A small black square should be at the bottom right corner of the outline of the cell. Click and drag this cell down; it should copy the formula the way you want.

    Szalapski

+ 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