![]() ![]() It saves time by copying the blocks of cells across rows and columns too.īelow is an example of how to use relative reference:Ī school health nurse has been asked to calculate students’ Body Mass Index. In particular, relative reference is frequently used when doing calculations in Excel, as it helps users to compute figures across scenarios and situations. It can be used with both numbers and text. It will change accordingly if Cell B3 changes.įlexible in nature and easy to apply, relative reference is one of the most commonly used functions in Excel. Now Cell D3 is a relative reference to Cell B3. In the formula of Cell D3, Enter “ =” (the equal sign) and then select the point of reference - Cell B3.Choose a cell where you would like to create a relative reference. Cell D3 in this example:.Here are the steps on how to make a basic relative reference in Excel ( =D3) How to make a relative reference in Excel Simply the relative row and column coordinates are required. There’s no dollar sign ($) required in the formula. In Excel, all references are relative by default. When the cell references are being copied to the rest of the cells, they change simultaneously to multiply the Unit Price by Sold Quantity for each row, as shown in the image below. For example, to find out the total sales of each plant type sold, we would multiply Unit Price by Sold Qty (or =B2*C2) in Excel.
0 Comments
Leave a Reply. |