Click to start the search Calculation operators and previously Operators specify the type of calculation to perform on the elements of a formula. Although there is a predefined order of execution of the calculations, you can modify it using the brackets. In this article -------------------------------------------------- ------------------------------ Types of operators Order of execution of operations in formulas -------------------------------------------------- ------------------------------ Types of operators There are four types of calculation operators: arithmetic, comparison, text and reference. Arithmetic Operators To perform basic mathematical operations such as addition, subtraction, or multiplication; operate on numbers and generate the numerical results, use the following arithmetic operators: Arithmetic operator Meaning Example + (Plus sign) Addition 3 +3 - (Minus sign) Subtraction Denial 3-1 -1 * (Asterisk) Multiplication 3 * 3 / (Division sign) Division 3/3 % (Percent sign) Percentage 20% ^ (Caret) Exponentiation 3 ^ 2 Comparison Operators You can compare two values with the operators listed below. If two values are compared by using these operators the result is a logical value of TRUE or FALSE. Comparison operator Meaning Example = (Equal sign) Equal to A1 = B1 > (Greater than sign) Greater than A1> B1 = B1
Posted on: Sat, 08 Jun 2013 08:56:57 +0000
Trending Topics
Recently Viewed Topics
© 2015