Percent sign (%)You use percent sign to display the value of the cell as percentage. For example, divide value1 by value2 and then multiply value3 to the result.II.1.5. Forward slash(/)You use forward slash to divide numeric values.
#Microsoft office excel 2007 tutorial pdf pdf#
Ms Excel Formulas Tutorial 2007 Pdf Ms Excel 2007 Formula Tutorial Pdf Downloadįor example, multiply value1 by value2 and then subtract value3 to the result.II.1.4. Asterisk (.)Asterisk is used to multiply numeric values. Minus sign (-)Minus sign (-) is used to subtract two or more numeric values or represent negative values.įor instance, subtract value1 by value2.II.1.3.
For example, add value1 and value2.II.1.2. Plus sign (+)Plus sign (+) is used to add two or more numeric values. (asterisk)Multiplication5.5/ (Forward slash)Division5/2% (percent sign)Percent30%^ (caret)Exponentiation5^2II.1.1. Arithmetic operatorMeaningExample+ (plus sign)Addition5+5- (minus sign)SubtractionNegation5-3-2. Arithmetic operatorsThe following arithmetic operators use to perform basic mathematic operation such as addition, subtraction, multiplication, or division combine number and produce numeric result. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference. Using calculation operators in formulaYou use operators to perform calculation on the elements of a formula. Ms Excel 2007 Formula Tutorial Pdf Download.Operators: The + (plus sign) operator adds values, and the. Constants: Numbers or text values enter directly into a formula, such as 2.3.
References: A2 and B2 return the values in cell A2 and B2.2. For instance, the following formula subtract 12 by 5 and then multiplies 3 to the result.=(12-5).3A formula can contain any or all of the following: functions, references, operators, and constants.1. FormulasFormulas are equations that start with equal sign (=) and perform calculation on values in your worksheet. Microsoft Excel 2007 tutorial: formulasFormulas I.
0 kommentar(er)
