Question: how to make a formula work in excel?
Answer: Select a cell. Type the equal sign =. Note: Formulas in Excel always begin with the equal sign. Select a cell or type its address in the selected cell. Enter an operator. ...  Select the next cell, or type its address in the selected cell. Press Enter.