Forum Discussion
Segalassoc
May 31, 2021Copper Contributor
Multiplying multiple cells of data at once
I am trying to multipy 150 individual cells by the same constant, 2.2
I am able to do it one cell at a time but can not figure out how to highlight 100+ cells and do them all at the same time. I'm a newbie, so thanks for a simple lesson?
4 Replies
Sort By
Depends how your data is structured. Let assume it's in A1:A100. In B1 enter the formula =A1*2.2
After when stay on B1 double click the dot on the border around the cell at bottom right.
Alternatively after entering the formula select B1:B100 and Ctrl+D.
- SegalassocCopper ContributorThank you for replying.
When I highlight one cell, the formula bar shows: 617.554245
The 617 is the date, in this case the cost. I can type in the formula line =617.554245*2.2 and when I hit return the result is correct. When I try and highlight a number of cells, that doesn't work?First step
Double click on dot at the bottom right of B1. Result is
Another way - after first step select range in column B
Press Ctrl+D. Result will be the same.
If you'd like multiply numbers in column A substituting them with the result, when as JoeUser2004 advised.