zxing qr code c# example For more on logical functions, see Understanding Logical Functions on page 421. in C#

Generate QR-Code in C# For more on logical functions, see Understanding Logical Functions on page 421.

13

You can use a range name as an argument to a function. For example, if you use the Insert, Name, Define command to assign the name QtrlyIncome to the range C3:C6, you can use the formula =SUM(QtrlyIncome) to total the numbers in cells C3, C4, C5, and C6.

You can use an array as an argument in a function. Some functions, such as TREND and TRANSPOSE, require array arguments; other functions don t require array arguments but do accept them. Arrays can be composed of numbers, text, or logical values.

You can mix argument types within a function. For example, the formula =AVERAGE(Group1,A3,5*3) uses a range name (Group1), a cell reference (A3), and a numeric expression (5*3) to arrive at a single value. All three are acceptable.

The easiest way to locate and insert built-in functions is by clicking the Insert Function button. When you do, the dialog box shown in Figure 13-5 appears.

Using Functions If you re not sure what function you need, enter a description of what you are trying to do into the Search box. For example, if you enter I want to know how many cells contain values and then press Go, the Insert Function dialog box returns a list of recommended functions, similar to the list shown in Figure 13-6. As it turns out, the first function in the list of suggestions fills the bill. If you don t find the function you re looking for, try rewording your query.

Figure 13-6. Ask a question in the Search box, and Excel suggests some possible functions you can try.

You can also select a function category from the drop-down list to display all the applicable functions available. Function categories include Financial, Date & Time, Lookup & Reference, Text, and more. The Recommended category keeps track of any functions returned as a result of using the Search box. When you select a function, the syntax and a brief description appear at the bottom of the dialog box. You can obtain help on a function selected in the Select A Function list by clicking the Help On This Function link at the bottom of the dialog box. When you select a function and click OK, Excel enters an equal sign to start a formula in the active cell, inserts the function name and a set of parentheses, and displays the Function Arguments dialog box, shown in Figure 13-7.

13

13

Figure 13-7. The selected function appears in the Function Arguments dialog box, where you can find more information about the function and each selected argument.

Tip Shrink the Function Arguments Drag the Function Arguments dialog box around on the screen if you need to see the cells under it. For maximum viewing, shrink the dialog box by clicking one of the collapse buttons at the right side of the argument boxes. The Function Arguments dialog box contains one box for each argument of the selected function. If the function accepts a variable number of arguments (such as SUM), the dialog box grows as you enter additional arguments. A description of the argument box currently containing the insertion point appears near the bottom of the dialog box. To the right of each argument box, a display area shows the current value of the argument. This display is very handy when you are using references or defined names, as the value of each argument is calculated for you. The current value of the function (Formula Result) appears at the bottom of the dialog box. Some functions, such as INDEX, have more than one form. When you select a function from the Insert Function dialog box that has more than one form, Excel presents the Select Arguments dialog box, shown in Figure 13-8, in which you select the form you want to use.