Use Pointing to Enter Cell References. Double-click the fill handle in the formula. In Excel we have a function called MMUL an array function.
Multiply To multiply numbers in Excel use the asterisk symbol or the PRODUCT function.
Multiply 7 by 10 and youd get 70 a totally different answer. Multiply a column of numbers by a constant number Type A2B2 in a new column in your spreadsheet the above example uses column D. Multiply To multiply numbers in Excel use the asterisk symbol or the PRODUCT function. Now add the 5 to get and answer of 25.