Question: how to create a nested formula in excel?
Answer: Click the cell in which you want to enter the formula. To start the formula with the function, click Insert Function on the formula bar . ...  In the Or select a category box, select All. ...  To enter another function as an argument, enter the function in the argument box that you want.