Manual excel office & formulas

Solo disponible en BuenasTareas
  • Páginas : 9 (2120 palabras )
  • Descarga(s) : 0
  • Publicado : 22 de septiembre de 2010
Leer documento completo
Vista previa del texto
Converter Office: Converts documents to Office 2003 or 2007

Office Excel Manualórmulas overview


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 formulasums 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.
[pic] 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 Insert Function [pic]on the formula bar [pic].
Excel inserts theequal sign (=) for you.
3. Select the function that you want to use.
If you're not sure which function to use, you can type 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 worksheetfunctions (alphabetical) or List of worksheet functions (by category).
4. To enter the arguments, do one or more of the following:
• To enter cell references as an argument, click Collapse Dialog [pic]next to the argument you want (which temporarily hides the dialog box), select the cells on the worksheet, and then press Expand Dialog [pic].
• 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.
• The parts of the formula displayed in the Function Arguments dialog box reflect the function that you selected in the previous step. For example, if you clicked IF, the Function arguments dialog box displays the arguments for the IF function.
Create anarray formula that calculates a single result
You can use an array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) to perform several calculations to generate a single result. This type ofarray formula can simplify a worksheet model by replacing several different formulas with a single array formula.
3. Click the cell in which you want to enter the array formula.
4. Enter the formula that you want to use.
 Tip   Array formulas use standard formula syntax. They all begin with an equal sign, and you can use any of the built-in Excel functions in your array formulas.
Forexample, the following formula calculates the total value of an array of stock prices and shares, without using a row of cells to calculate and display the total values for each stock.
Array formula that produces a single result
When you enter the formula {=SUM(B2:C2*B3:C3)} as an array formula, Excel multiples the number of shares by the price for each stock (500*10 and 300*15),and then adds the results of those calculations together to get a total value of 9500.
Excel automatically inserts the formula between { } (a pair of opening and closing braces).
 Note   Manually typing braces around a formula will not convert it into an array formula — you must press CTRL+SHIFT+ENTER to create an array formula.
 Important   Any time you...
tracking img