Build Excel formulas
Deterministic IF/SUMIFS/XLOOKUP templates; no AI or formula execution. Canonical English names; comma/semicolon separator.
- Runs in your browser
- No upload
- Check before download
Processed on this device; files are never uploaded. Deterministic IF/SUMIFS/XLOOKUP templates; no AI or formula execution. Canonical English names; comma/semicolon separator. Typed cell/text/number values; valid A1/XFD references,100000-cell ranges and10 criteria. XLOOKUP needs Excel2021/365, exact match. Worked examples are stated fixtures.
Worked example · IF
| Cell reference | Value |
|---|---|
| A1 | 12 |
=IF(A1>=10,1,0)Expected result: 1
Preview
- Choose a function
Choose IF, SUMIFS or exact-match XLOOKUP for the task you want to do. You don't need a workbook file.
- Configure references and criteria
Enter the condition, ranges, criteria or lookup arguments the tool supports. Select a comma or semicolon separator, and fix any validation errors before you copy.
- Copy and test the formula
Check the cell references, the quoted criteria and the comma or semicolon separator you selected. Try the copied formula on known sample values in the spreadsheet application you plan to use. Refentra builds the formula text only. It doesn't run a workbook or promise that the formula works in every language setting or application.
Properties
How are my source files or values handled?
Processed on this device; files are never uploaded. Deterministic IF/SUMIFS/XLOOKUP templates; no AI or formula execution. Canonical English names; comma/semicolon separator. Typed cell/text/number values; valid A1/XFD references,100000-cell ranges and10 criteria. XLOOKUP needs Excel2021/365, exact match. Worked examples are stated fixtures.
Output
Deterministic IF/SUMIFS/XLOOKUP templates; no AI or formula execution. Canonical English names; comma/semicolon separator. Typed cell/text/number values; valid A1/XFD references,100000-cell ranges and10 criteria. XLOOKUP needs Excel2021/365, exact match. Worked examples are stated fixtures.
What should I check in the output?
Check the cell references, the quoted criteria and the comma or semicolon separator you selected. Try the copied formula on known sample values in the spreadsheet application you plan to use. Refentra builds the formula text only. It doesn't run a workbook or promise that the formula works in every language setting or application.