Question: how to create a formula in excel for dummies?
Answer: First, you must populate the spreadsheet with data. Open a new Excel file and select cell C1 to make it the active cell. Type 3 in the cell, then press Enter on your keyboard. Cell C2 should be selected. ...  Now create the formula. ...  Press Enter to complete the formula.