Formula Builder

Build Excel and Google Sheets formulas for lookups, conditional logic, totals, text cleanup, dates, and percentage calculations.

Formula typeSpreadsheetSeparatorError handling

Lookup/criteria cellData/rangeReturn/sum range

Describe the spreadsheet task

Generated formula and notes

Choose a formula type or load the sample to begin.

Free Online Formula Builder

Choose a formula pattern, enter the cell/range details, and generate a ready-to-copy Excel or Google Sheets formula with plain-English notes.