Nesting functions in the functions dialog box
 

In a previous version of Excel, the function dialog box contained a control
button to activate the function command in order to create a new function
within the function being completed. This control button was removed in
later versions of Excel. This button is useful when you need to nest
functions and aren't sure about the syntax of the nested function. Does
anyone know how to accomplish this under the newer versions of Excel without
having to close the dialog box repeatedly?