With the COLUMN and ROW functions in Excel, you can return the position number of a cell. Use the Reference Number of a Given Cell: COLUMN and ROW ![]() RELATED: How to Add or Multiply Values with Paste Special in Microsoft Excel 10. To find the product of cells A2 through A10, you would enter the following and hit Enter: =PRODUCT(A2:A10)Īs you can see, this is much simpler than entering A2 * A3 * A4, and so on. You can use value1 for the cell range and value2 for an additional cell range if needed. The syntax is PRODUCT(value1, value2.) with value1 required and value2 optional.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |