Quick excel question

Discussion in 'Tech' started by pk_volt, Feb 12, 2008.

  1. pk_volt New Member

    Posts:
    407
    Trophy Points:
    0
    If I input a column of numbers.

    How do I do a math expression of ALL the numbers and place the results into the 2nd column

    for example

    I have a column of different times in seconds, and I want to convert all this data into m-seconds. and place it into the column beside the data.
  2. jake Vagabond

    Posts:
    3,728
    Trophy Points:
    0
    Location:
    Calgary, AB
    Enter the formula into the first cell then copy and paste it down the column. Excel will adjust the formula to reference the cell adjacent to it.
  3. pk_volt New Member

    Posts:
    407
    Trophy Points:
    0
    hm, I did someothing like =Log(E2/C2,10)
    I tried pasting this down the column, butit just gives me the same number
  4. ivwshane We are all old school!

    Posts:
    6,635
    Trophy Points:
    63
    Location:
    Earth
    It should be something like =SUM(A1:A2)
    So =function(begining cell:ending cell)
  5. jake Vagabond

    Posts:
    3,728
    Trophy Points:
    0
    Location:
    Calgary, AB
    Hmm, after you have entered it into the first cell, grab the little box in the bottom right corner of the cell and drag it down. I just tried the formula you entered and it worked fine for me.
  6. ivwshane We are all old school!

    Posts:
    6,635
    Trophy Points:
    63
    Location:
    Earth

    I don't know if your formula is right but what does the ,10 stand for? The way you have it is that it only takes cel e2 and divides it by c2.
  7. jake Vagabond

    Posts:
    3,728
    Trophy Points:
    0
    Location:
    Calgary, AB
    Its the base for the log function.
  8. pk_volt New Member

    Posts:
    407
    Trophy Points:
    0
    I went to our help desk at our school and the guy tought me to do the computation for one cell
    then click the lower right corner of the cell corner, and draw it all the way down the column

    worked like a charm!

    I guess I didn't explain what exactly I wanted to do clearly enough/

    thanks for all the effort though guys
  9. ivwshane We are all old school!

    Posts:
    6,635
    Trophy Points:
    63
    Location:
    Earth
    So what does the formula look like?