Wrap the cells in a selected range with a custom formula of your choice.
Try it - click the ribbon
| A | B | |
|---|---|---|
| 1 | FY25 | |
| 2 | Revenue | 1,284,500 |
| 3 | COGS | 962,300 |
| 4 | Opex | 214,750 |
Use Add Custom Formula when every cell in a selected range needs to be wrapped in a formula you define yourself.
Enter a valid custom formula pattern and apply it across all cells in the selected Excel range.
Transform a range consistently without opening and editing each formula cell individually.
Inside Excel
The demo above is a simplified web version. This is Add Custom Formula running in Excel.
Keep exploring
| Tool | What it does | Demo |
|---|---|---|
| Random Sample | Select a random sample from transactions, invoices, or other records for review. | Try it live |
| Random Values | Generate random values for sample datasets, model testing, and practice workbooks. | Try it live |
| Change Formula References | Switch selected formulas between absolute, relative, and mixed cell references. | Try it live |
| Select All | Select formula cells, numbers, text, or errors across the active worksheet in one step. | Try it live |
| Add IFERROR | Wrap selected formulas with IFERROR and choose what to display when a calculation returns an error. | Try it live |
| Add Rounding | Apply ROUND, ROUNDUP, or ROUNDDOWN across a selection without editing each formula. | Try it live |
