The solution is simple, do a copy (CTRL+C) in cell E2 that already contains a formula, then paste (CTRL+V) in the range E3:E5. If there are many items, then it will be a very time-wasting.

What about the other items subtotal? Should the formula be typed one by one for each cell phone? Of course not. 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. 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.

How to Create a Mixed Reference in ExcelĪs already discussed in the article “ How to Create a Formula in Excel“.How to Make an Absolute Reference in Excel.

What is a relative cell reference excel