• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

EXCEL question....

K

krunchykrome

Lifer
I have a set of data collumns A through I, rows 1-25. I need to take row 2 and multiply every cell by 50. I have to do this with each row (25 total), each row multiplied by a different figure. How can I take row 2, and multiple each cell by 50? I dont want to go into each cell and multiply the number by another.
 
Do the results of the multiplications have to be in Row 2 as well? I think this cannot be done without creating a temp row somewhere else on the worksheet (for which each cell will contain a formula like "=A1*50", of course the fill handle can be used to repeat the formula for all cells in the same row).

 
Originally posted by: ming2020
Do the results of the multiplications have to be in Row 2 as well? I think this cannot be done without creating a temp row somewhere else on the worksheet (for which each cell will contain a formula like "=A1*50", of course the fill handle can be used to repeat the formula for all cells in the same row).
Click to expand...
How can I do this?

 
In column B, in the first cell corresponding to your data in column A, write =A1*2. Then double-click the little dot at the bottom right corner of the cell and it will apply the formula to the rest of the column.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top