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.