How to multiply columns in Excel
To multiply two columns in Excel, write the multiplication formula for the topmost cell, for example:
=A2*B2
After you've put the formula in the first cell (C2 in this example), double-click the small green square in the lower-right corner of the cell to copy the formula down the column, up to the last cell with data:
.png)
Due to the use of relative cell references (without the $ sign), our Excel multiply formula will adjust properly for each row:
कोणत्याही टिप्पण्या नाहीत:
टिप्पणी पोस्ट करा