How to Create a Formula in Google Sheets

This guide provides step-by-step instructions on how to create formulas in Google Sheets, making it easier for users to perform calculations and automate tasks in spreadsheets.

Adrienne Todd
6 steps
33 seconds

Google Sheets

Click on the cell you'd like to type the formula in.

Type "=" to initiate a formula.

Type the first number you'd like in the formula, followed by a operator (e.g. an asterisk for multiplication).

A sample formula would be "=5\*10".

Press "enter" to complete the formula.

The result of your formula should be displayed in the cell.