Question: how do i create a formula in excel spreadsheet?
Answer: On the worksheet, click the cell in which you want to enter the formula.
Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes: ... 
Press Enter (Windows) or Return (Mac).