Formula hub · Updated May 13, 2026

Comparisons

Choose the right formula by comparing similar functions, tradeoffs, and platform differences.

Guides in this category

XLOOKUP vs VLOOKUP

Compare XLOOKUP and VLOOKUP so you can choose the safer lookup formula for your spreadsheet.

SUMIF vs SUMIFS

Choose between SUMIF and SUMIFS based on how many conditions your sum needs.

Excel vs Google Sheets Formulas

Compare formula behavior, availability, arrays, lookup functions, and QUERY support in Excel and Google Sheets.

Excel Formula Cheat Sheet

A practical cheat sheet of common Excel formulas for lookup, counting, text cleanup, dates, and errors.

Google Sheets Formula Cheat Sheet

A quick reference for useful Google Sheets formulas including QUERY, FILTER, ARRAYFORMULA, TEXTJOIN, and lookup formulas.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.