The result is the price to be paid for two iPhoneX 256GB. Here are the steps for calculating subtotals. First, calculate the subtotal for each cell phone by multiplying the price and the quantity of each cell phone. How much money should be paid to buy all these gifts? He bought two iPhoneXs for both his parents, 1 Galaxy S9 + for his wife, 3 Moto G6 for his sisters and 4 Honor 7X for his friends.
Each cell address used in creating formulas by default uses a relative cell reference.įor example, there are data such as the image below.
#Define relative cell reference excel how to
There is no specific way how to use relative reference in excel because the relative cell reference is the default cell reference used in excel. Relative Reference excels default behavior for all formulas. When a cell address contains a formula copied and cell address changing according to the new cell address location, that is a relative cell reference. By default, the cell address used by the formula will change to adjust the location of the new cell.Įxcel provides three options to set a reference to the cell if the cell contains a formula copied, i.e., relative cell reference, absolute cell reference and mixed cell reference Relative Cell Reference What is Relative Cell Reference? If a cell contains a formula copied to another cell, it will generate a cell containing a formula as well.