Being the huge nerd I am I can't believe I don't know how to use excel, but I need some help. I need to multiply the column A values by a number and have them in column C in the same row. Eventually I also need to do the same to column B values and put them in D, etc.

Where do I start? I get how to work with columns and gets totals, but not sure how to do it on rows and make it keep doing it.

 

I used to know how to do just about everything on excel, but of course, since I haven't used it in the last couple years I don't remember. I think I've still got my old textbook from computer class. I'll look around and see if I can find it and see if I can help ya.

 

In the cell you want the final value to appear in, type this:

=PRODUCT(Cell1, NumberValueToMultiplyBy)


Example:

If you want the value of Cell A1 to be multiplied by 10 to be shown in Cell C1, in Cell C1 you would type:

=PRODUCT(A1,10)




Kris

 

cool, now is there any way for me to do that on every row? I have ~150 rows with numbers in them, all need to be multiplied by the same number.

 

Yeah, if you highlight the cells the formula should automatically populate for you.



Kris

 

thanks guys, finally figured it out. It seems the people who know how to use excel forget the people who don't don't know how to use excel don't know the autofill function by dragging the bottom right of the cell. Even my excel expert mother (an accountant) failed to explain how to use it.

Its all good though. Went from 230 cells of data to 5 functions and over 1200 cells of useful data. Hopefully that pulls me another 10% on my lab report when I don't know what the hell I'm doing.