For example, arguments specify the numbers or cells you want to add.Īfter you type the first letter of a function name, the AutoComplete list appears. Arguments are values on which you want to perform the calculation. When using a function, remember the following: Not the operators, such as +, -, *, or /. Understanding Functionsįunctions differ from regular formulas in that you supply the value but The referenceĪ7,B8:B10,C9,10 refers to cells A7, B8 to B10, C9 and the number 10. A union referenceĬonsists of two or more numbers, range references, or cell addresses separated by a comma. ![]() The referenceĪ1:C3 includes cells A1, A2, A3, B1, B2, B3, C1, C2, and C3.Ī union reference includes two or more references. The reference A1:A3 includes cells A1, A2, and A3. A range reference consists of two cell addresses separatedīy a colon. ![]() Types of reference operators: range and union.Ī range reference refers to all the cells between and including the Reference operators refer to a cell or a group of cells. ![]() To use functions, you need to understand reference operators.
0 Comments
Leave a Reply. |