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.