write formula to multiply values of cell A2 and B2
Answers
Answered by
0
Multiply a column of numbers by a constant number
1. Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER
2. Drag the formula down to the other cells in the column.
1. Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER
2. Drag the formula down to the other cells in the column.
Similar questions