Generate ready-to-paste Excel formulas for SUM, IF, VLOOKUP, COUNTIF, SUMIF, AVERAGE, CONCATENATE, and IFERROR. Fill in the fields — get the formula instantly.
Pick a formula type from the tabs, fill in the cell references and values, then click "Generate Formula". Copy it and paste directly into Excel or Google Sheets.
Use standard Excel notation: A1 for a single cell, A1:A100 for a range, B2:E50 for a multi-column range. Column letters are not case-sensitive.
Use VLOOKUP to find a value in one column and return a corresponding value from another — like looking up a product code to get its price. Always use FALSE for exact match.
Formula generation happens entirely in your browser. No data is sent to servers. Works offline once the page is loaded. Always free, no account needed.