I'm trying to create nested functions within excel in order to execute if/then outcomes. Does anyone know how to activate the function wizard as suggested by MS without using the mouse.also suggested as below?
Create a formula by using nested functions Nested functions use a function as one of the arguments of another function. You can nest up to 64 levels of functions. The following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5) is greater than 50. Otherwise, it returns 0. Nested functions 1. The AVERAGE and SUM functions are nested within the IF function. 1. Click the cell in which you want to enter the formula. 2. To start the formula with the function, click Function Wizard Button imageon the formula bar Button image. 3. Select the function that you want to use. You can enter a question that describes what you want to do in the Search for a function box (for example, "add numbers" returns the SUM function), or browse from the categories in the Or Select a category box. Tip For a list of available functions, see List of worksheet functions (alphabetical) <http://www.office.com/redir/HA010277524> or List of worksheet functions (by category) <https://support.office.com/en-us/article/List-of-worksheet-functions-by-cat egory-7fd9655a-4e87-400a-ae5c-c48f16afde0c> . 4. To enter the arguments, do one or more of the following: o To enter cell references as an argument, click Collapse Dialog Button imagenext to the argument you want (which temporarily hides the dialog box), select the cells on the worksheet, and then press Expand Dialog Button image. o To enter another function as an argument, enter the function in the argument box that you want. For example, you can add SUM(G2:G5) in the Value_if_true edit box of the IF function. o -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: image001.gif Type: image/gif Size: 1171 bytes Desc: not available URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment.gif> -------------- next part -------------- A non-text attachment was scrubbed... Name: image002.gif Type: image/gif Size: 360 bytes Desc: not available URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment-0001.gif> -------------- next part -------------- A non-text attachment was scrubbed... Name: image003.gif Type: image/gif Size: 167 bytes Desc: not available URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment-0002.gif> -------------- next part -------------- A non-text attachment was scrubbed... Name: image004.gif Type: image/gif Size: 149 bytes Desc: not available URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment-0003.gif> -------------- next part -------------- A non-text attachment was scrubbed... Name: image005.gif Type: image/gif Size: 146 bytes Desc: not available URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20141130/39ca760e/attachment-0004.gif> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
