Question: how do you make your own formula in excel?
Answer: Press Alt + F11. ...  Choose Insert→Module in the editor. ...  Type this programming code, shown in the following figure: ...  Save the function. ...  Return to Excel. Click the Insert Function button on the Formulas tab to display the Insert Function dialog box. ...  Click OK.