# How to Create a Custom Formula in MS Excel

> To create a custom formula in Microsoft Excel, select a cell, type an equals sign, and enter the function name. Select the function, add a cell reference or range, and close with a parenthesis. Add operators and additional functions as needed, then press Enter to run the formula.

Canonical: https://livedemo.ai/tutorials/how-to-create-a-custom-formula-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a368fab56e05a00fdb54b/preview?step=1

## Steps

1. Inside your Microsoft Excel worksheet, select the cell where you wish to run the custom formula.
2. After that, type an 'Equals' (=) sign to indicate that your succeeding input is a formula.
3. Type the name of the function you wish to use and then select it from the suggested results.
4. Next, enter the cell reference or cell range and then end the formula with a closing parenthesis.
5. Input an operator or separator if you want to add another condition.
6. Subsequently, type the name of the function and then select it from the recommended matches.
7. Add the cell range or cell reference you wish to use as the argument.
8. Once done, insert a closing parenthesis to end the formula. If you want to add more condition, simply repeat the same series of steps.
9. Finally, press the 'Enter' or 'Return' key to run the newly created formula and view the results.