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.
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.
hm, I did someothing like =Log(E2/C2,10) I tried pasting this down the column, butit just gives me the same number
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.
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.
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