FP

FormulaPilot

Spreadsheet formula tools

Open generator
Google Sheets

Google Sheets formula reference — every function, every difference from Excel.

Most Excel formulas work identically in Google Sheets. This reference documents the ones that don't — syntax changes, missing functions, and Google-specific alternatives — alongside copy-ready worked examples.

Generate a Google Sheets formulaGoogle Sheets generator guide

EDATE

Works in Google Sheets

EDATE works identically in Google Sheets.

1 exampleSee in Sheets →

AVERAGEIFS

Works in Google Sheets

AVERAGEIFS works identically in Google Sheets.

1 exampleSee in Sheets →

WORKDAY

Works in Google Sheets

WORKDAY works identically in Google Sheets.

1 exampleSee in Sheets →

PMT

Works in Google Sheets

PMT works identically in Google Sheets.

1 exampleSee in Sheets →

SUMPRODUCT

Works in Google Sheets

SUMPRODUCT works identically in Google Sheets.

1 exampleSee in Sheets →

DATEDIF

Works in Google Sheets

DATEDIF works in Google Sheets but is undocumented. Use the same syntax: =DATEDIF(start, end, unit).

1 exampleSee in Sheets →

FV

Works in Google Sheets

FV works identically in Google Sheets.

1 exampleSee in Sheets →

IRR

Works in Google Sheets

IRR works identically in Google Sheets.

1 exampleSee in Sheets →

NPV

Works in Google Sheets

NPV works identically in Google Sheets.

1 exampleSee in Sheets →

SLN

Works in Google Sheets

SLN works identically in Google Sheets.

1 exampleSee in Sheets →

RATE

Works in Google Sheets

RATE works identically in Google Sheets.

1 exampleSee in Sheets →

ISBLANK

Works in Google Sheets

ISBLANK works identically in Google Sheets.

1 exampleSee in Sheets →

CONCAT

Works in Google Sheets

CONCAT works identically in Google Sheets. Note: the ampersand & operator also concatenates in both platforms.

1 exampleSee in Sheets →

AND

Works in Google Sheets

AND works identically in Google Sheets.

1 exampleSee in Sheets →

VALUE

Works in Google Sheets

VALUE works identically in Google Sheets.

1 exampleSee in Sheets →

PROPER

Works in Google Sheets

PROPER works identically in Google Sheets.

1 exampleSee in Sheets →

LEN

Works in Google Sheets

LEN works identically in Google Sheets.

1 exampleSee in Sheets →

TODAY

Works in Google Sheets

TODAY() works identically in Google Sheets.

1 exampleSee in Sheets →

COUNTIFS

Works in Google Sheets

COUNTIFS works identically in Google Sheets.

1 exampleSee in Sheets →

IFS

Works in Google Sheets

IFS works identically in Google Sheets.

1 exampleSee in Sheets →

MID

Works in Google Sheets

MID works identically in Google Sheets.

1 exampleSee in Sheets →

UNIQUE

Works in Google Sheets

UNIQUE works identically in Google Sheets.

1 exampleSee in Sheets →

MONTH

Works in Google Sheets

MONTH works identically in Google Sheets.

1 exampleSee in Sheets →

LEFT

Works in Google Sheets

LEFT works identically in Google Sheets.

1 exampleSee in Sheets →

RIGHT

Works in Google Sheets

RIGHT works identically in Google Sheets.

1 exampleSee in Sheets →

FILTER

Minor differences

FILTER is available in Google Sheets but uses semicolons to separate multiple conditions: =FILTER(A:A, (B:B="East")*(C:C="Q1")) using multiplication instead of a second FILTER argument.

1 exampleSee in Sheets →

MAXIFS

Works in Google Sheets

MAXIFS works identically in Google Sheets.

1 exampleSee in Sheets →

LARGE

Works in Google Sheets

LARGE works identically in Google Sheets.

1 exampleSee in Sheets →

COUNTIF

Works in Google Sheets

COUNTIF works identically in Google Sheets.

1 exampleSee in Sheets →

SEQUENCE

Works in Google Sheets

SEQUENCE works identically in Google Sheets.

1 exampleSee in Sheets →

EOMONTH

Works in Google Sheets

EOMONTH works identically in Google Sheets.

1 exampleSee in Sheets →

HLOOKUP

Works in Google Sheets

HLOOKUP works identically in Google Sheets.

1 exampleSee in Sheets →

SWITCH

Works in Google Sheets

SWITCH works identically in Google Sheets.

1 exampleSee in Sheets →

STDEV

Works in Google Sheets

STDEV works identically in Google Sheets.

1 exampleSee in Sheets →

IF

Works in Google Sheets

IF works identically in Google Sheets.

1 exampleSee in Sheets →

NETWORKDAYS

Works in Google Sheets

NETWORKDAYS works identically in Google Sheets.

1 exampleSee in Sheets →

TRIM

Works in Google Sheets

TRIM works identically in Google Sheets.

1 exampleSee in Sheets →

CLEAN

Works in Google Sheets

CLEAN works identically in Google Sheets.

1 exampleSee in Sheets →

SUBSTITUTE

Works in Google Sheets

SUBSTITUTE works identically in Google Sheets.

1 exampleSee in Sheets →

LET

Not available

LET is not available in Google Sheets. Use helper columns or LAMBDA (available in newer Google Sheets versions) as an alternative.

1 exampleSee in Sheets →

TEXT

Works in Google Sheets

TEXT works identically in Google Sheets with the same format codes.

1 exampleSee in Sheets →

SORT

Minor differences

SORT is available in Google Sheets. The argument order differs slightly — use =SORT(range, sort_column, is_ascending) where is_ascending is TRUE or FALSE.

1 exampleSee in Sheets →

SUMIFS

Works in Google Sheets

SUMIFS works identically in Google Sheets with the same argument order.

1 exampleSee in Sheets →

IFERROR

Works in Google Sheets

IFERROR works identically in Google Sheets.

1 exampleSee in Sheets →

TEXTJOIN

Works in Google Sheets

TEXTJOIN works identically in Google Sheets.

2 examplesSee in Sheets →

INDEX

Works in Google Sheets

INDEX works identically in Google Sheets.

1 exampleSee in Sheets →

ISNUMBER

Works in Google Sheets

ISNUMBER works identically in Google Sheets.

1 exampleSee in Sheets →

VLOOKUP

Works in Google Sheets

VLOOKUP works identically in Google Sheets. Syntax, arguments, and behaviour are the same.

1 exampleSee in Sheets →

XLOOKUP

Not available

XLOOKUP is not available in Google Sheets. Use VLOOKUP with an exact match, or the MATCH + INDEX combination instead.

1 exampleSee in Sheets →