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.