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.