How to Create a Custom Formula in Microsoft Excel

‍

‍

It is very easy to create a custom formula in Microsoft Excel. Here’s a quick guide on how to do it:

‍

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.