How to Enter Formula in Excel?

Select the cell where you want the result to appear

Type = to begin the formula

Enter the cell references, numbers, operators, or functions you want to use

Press Enter to calculate and display the result

Use the formula bar if you prefer to type or edit the formula there

Start every formula with =

Use parentheses to control the order of calculations

Use cell references instead of typing values directly when possible

Copy formulas to other cells by dragging the fill handle

Edit a formula by double-clicking the cell or using the formula bar

Suggested for You

Trending Today