Multiply Numbers In Cells. Drag Cell E1s AutoFill handle right to Cell G1 and then drag down to the Cell G8. As a result the formula results in a number.
ValueWidthTextInputText ValueHeightTextInputText where WidthTextInput is the name of the text input control for the width and HeightTextInput is the name of the text input control for the height. The product function is the fastest way of multiplication between ranges. Now in the blank cell you have to type this PRODUCT formula.
To multiply values in cells A1 and B1 use this formula.
Hey AEngleking try this out. Under Table Tools on the Layout tab in the Data group click the Formula button. To multiply cells or ranges in excel we can use the PRODUCT function instead of using multiplication symbol. You can also multiply two different cells together.