Excel Relative Referencing
Relative referencing tells that you don't need to type the formula separately for each calculation in a column or a row. See the image:
Type the formula in the first cell D3 and press Enter key to get the result, then use the fill handle. The formula will change automatically in the respective cells and all values of list 1 will get multiplied with respective values of list 2.
This way you can easily multiply values of list 1 with respective values of list 2 but if you want to multiply all cells of list 1 with a single cell of list 2 such as C3 then it won't work.
JavaTpoint offers too many high quality services. Mail us on [email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected]
Duration: 1 week to 2 week