You can use the formula palette too?

Excel Training Level 2 Lesson 9 FREE EXCEL HELP The method I have described in the last lesson it not the simplest way to write a nested formula, but instead is designed to show you what is going on and hopefully help you understand how nesting works. We strongly suggest you practice writing small to medium nested formulas. This way to force yourself to understand how Excel wants it's nested formulas. Once you have understood this you can move on to a very simple way that will have Excel do all the opening and closing parenthesis for you. We do this with the Insert function. This is where Excel has nearly every single formula that it can accept. Insert Function The Insert Function was known as the Paste Function in older versions of Excel. This feature is used to insert or paste a selected function into the chosen cell. There are three methods we can use to show the Insert Function dialog and which one you use is purely optional. The three methods are: ·Going to Insert>Function ·Push Shift + F3 ·Click the Insert Function icon to the left of your Formula bar ( Fx), or for older version users, click the Paste Function icon on your Standard toolbar. Once activated you will see the Insert Function dialog pop up in front of you. Depending on which version of Excel you are using, these heading names may vary slightly in this dialog box. We will use the Insert Function dialog to help us write the above function. ·Under Or Select a Category select Logical then under Select a Funct...