This page is not available in every language. Missing translations are disabled in the language selector.

Quick reference

Spreadsheet Formulas Cheatsheet

Quick reference guide for spreadsheet formulas and functions across Excel and Google Sheets, covering logical conditions, math, and VLOOKUP.

Compiled by Cheat Sheets · PublishedOctober 24, 2026

Common formulas and lookup functions across Microsoft Excel and Google Sheets.

Logical Functions

=IF(logical_test, value_if_true, value_if_false)
=IF(A1 > 100, "High", "Low")

=IFS(A1 >= 90, "A", A1 >= 80, "B", A1 >= 70, "C", TRUE, "F")
=AND(A1 > 0, B1 > 0)
=OR(A1 == "Yes", B1 == "Yes")

Lookup and Reference

# VLOOKUP: search key, range, column index, is_sorted
=VLOOKUP(lookup_value, table_array, col_index_num, FALSE)
=VLOOKUP(101, A2:D100, 3, FALSE)

# Modern XLOOKUP
=XLOOKUP(lookup_value, lookup_array, return_array, "Not Found")
=XLOOKUP(A1, Employees!A:A, Employees!B:B)

Mathematical and Statistical

=SUM(A1:A50)
=AVERAGE(B1:B20)
=COUNT(A1:A100)
=COUNTA(A1:A100)       # Count non-empty cells
=COUNTIF(A1:A100, ">50")

# Conditional Sum
=SUMIF(A1:A100, "Category A", B1:B100)
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)

Text Functions

=CONCATENATE(A1, " ", B1)
=TEXTJOIN(", ", TRUE, A1:A10)
=LEFT(A1, 4)
=RIGHT(A1, 2)
=MID(A1, 2, 5)
=TRIM(A1)
=UPPER(A1)
=LOWER(A1)
```\n

Related topics

#office #excel #sheets #formulas #vlookup