Someone needs to create formulas in Excel.
Let’s take an example of a simple formula.
1.On the worksheet, click the cell in which you want to enter the formula.
2.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.
Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.
Following the standard order of mathematical operations, multiplication and division is performed before addition and subtraction.
3.Press Enter (Windows) or Return (Mac)
Let’s take another variation of a simple formula. Type =5+2*3 in another cell and press Enter or Return. Excel multiplies the last two numbers and adds the first number to the result.