Excel: Sounds Good (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

Use the Names In the previous pages there were many instances where you typed in the Named Range into the various Function Arguments. There is another method for adding the Named Range into your equation.   Try This: Use in Formula Go to the Conditional Formulas sheet and select cell E65.   Go to  Formulas ->Name Manager -Select: Use in Formula.   What Do You See? All of the Named Ranges you created should be listed.   Memo to self: The Computer Mama got started on the wrong foot a couple of times with this tool. Better practice this one!

Formulas ->Name Manager ->Use in Formula