Section 11. Entering and Editing Formulas

After you've entered data into your spreadsheet, you need to work with those numbers to create other numbers. You do this as you would in the real world, by using common formulas to calculate your data by addition, subtraction, multiplication, and division. You can also used advanced formulas preprogrammed into Google Spreadsheets; these advanced formulas are called functions and are explained in the next section.

If you're an Excel user, you're used to using formulas. If you're new to spreadsheets, it helps to know that a formula is a mathematical expression that defines the relationship between two or more values. In Google Spreadsheets, formulas are used to calculate values for specific cells and can ...

Get Using Google™ Spreadsheets now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.