---
title: "Spreadsheet Formulas Cheatsheet | FindUtils"
description: "Use basic Excel and Google Sheets formulas for totals, conditions, text, percentages, and rounding. Check references and locale separators."
url: https://findutils.com/cheatsheets/spreadsheet-formulas/
---

# Spreadsheet Formulas Cheatsheet

Use basic Excel and Google Sheets formulas for totals, conditions, text, percentages, and rounding. Check references and locale separators. 38 shortcuts in 7 sections, filed under [Shortcuts & Productivity](https://findutils.com/cheatsheets/shortcuts/).

## Before you enter a formula

- `Excel and Google Sheets`: These basic formulas use English function names
- `=SUM(A2:A10)`: Start a formula with =; this example adds a range
- `Comma separators`: Some locales use semicolons between function arguments
- `A2:A10`: A colon includes both ends of the cell range
- `Example cells`: Replace the cell references with your own data

## References and arithmetic

- `=A2+B2`: Add two cell values
- `=A2-B2`: Subtract B2 from A2
- `=A2*B2`: Multiply two cell values
- `=A2/B2`: Divide A2 by B2; B2 must not be zero
- `=(A2+B2)*C2`: Calculate the bracketed sum first
- `=A2*$B$1`: Keep B1 fixed when you copy the formula

## Totals and counts

- `=SUM(B2:B10)`: Add the numeric values in the range
- `=AVERAGE(B2:B10)`: Find the mean; ignore empty cells and text in the range
- `=MIN(B2:B10)`: Find the smallest numeric value
- `=MAX(B2:B10)`: Find the largest numeric value
- `=COUNT(B2:B10)`: Count cells with numeric values
- `=COUNTA(B2:B10)`: Count nonempty cells, including formulas that return empty text

## Conditions

- `=IF(B2>=50,"Pass","Review")`: Choose a result from one condition
- `=COUNTIF(A2:A10,"Done")`: Count cells that match the text
- `=SUMIF(A2:A10,"Food",B2:B10)`: Add B values where the corresponding A value matches
- `=AND(B2>=0,B2<=100)`: Check whether both conditions are true
- `=OR(A2="Yes",B2="Yes")`: Check whether at least one condition is true
- `=IFERROR(A2/B2,"Check input")`: Replace any formula error; inspect the cause before use

## Clean and combine text

- `=TRIM(A2)`: Remove extra ordinary spaces; nonbreaking spaces can remain
- `=LEN(A2)`: Count characters, including spaces
- `=LEFT(A2,3)`: Read the first three characters
- `=RIGHT(A2,4)`: Read the last four characters
- `=LOWER(A2)`: Convert text to lowercase
- `=A2&" "&B2`: Join two values with a space

## Percentages and rounding

- `=B2/A2`: Find a part of a nonzero total; format the result as a percentage
- `=A2*(1-B2)`: Apply a discount when B2 contains a rate such as 20%
- `=ROUND(A2,2)`: Round to two decimal places
- `=ROUNDUP(A2,0)`: Round away from zero to an integer
- `=ROUNDDOWN(A2,0)`: Round toward zero to an integer

## Sources and related references

- `https://support.microsoft.com/en-us/excel/get-started/overview-of-formulas-in-excel`: Read the Excel formula and reference rules
- `https://support.google.com/docs/table/25273?hl=en`: Check the Google Sheets function list
- `/cheatsheets/percentages-ratios/`: Check the percentage calculations behind the formulas
- `/cheatsheets/everyday-file-formats/`: Compare workbook and CSV formats

## Related

- Cheatsheet: [Windows 11 Keyboard Shortcuts](https://findutils.com/cheatsheets/windows-shortcuts/)
- Cheatsheet: [Mac Keyboard Shortcuts](https://findutils.com/cheatsheets/mac-shortcuts/)
- Cheatsheet: [Chrome Browser Shortcuts](https://findutils.com/cheatsheets/browser-shortcuts/)
- Guide: [Remove Duplicate Rows From a CSV by Email, ID or Any Column](https://findutils.com/guides/csv-dedupe/)
- Guide: [Compare Two CSV Files by ID: Find Added, Removed and Changed Rows](https://findutils.com/guides/csv-diff/)
- Guide: [Convert TSV to CSV (and CSV to TSV) in Your Browser with Correct Quoting](https://findutils.com/guides/tsv-to-csv/)
- Tool: [Spreadsheet Editor](https://findutils.com/productivity/spreadsheet-editor/)
- Tool: [CSV to Excel](https://findutils.com/convert/csv-to-excel/)
- Tool: [TSV to CSV](https://findutils.com/convert/tsv-to-csv/)