While you are working with a Google Spreadsheet where some formulas are needed to be copied down to the last row of your sheet. You may also need the formula to be added automatically when a new row is added to your Google Sheet. There are several ways to solve this kind of problem.
1. Open your spreadsheet in Google sheet.
Enter your data in your working cell.
2.Input the formulae in cells then click enter
3. Drag cursor on the entire column to fill the remaining cells. Your cell combinations will be displayed in every cell in column C for each cell.
After inputting the formulae and getting the result. You may double click the result cell before dragging so it feels the entire column.