The “asterisk,” “forward slash,” and “caret” are used for multiplication, division, and exponentiation respectively. These operators are used in calculations to generate numeric output. The arithmetic operators like “plus” (+), “minus” (-), “asterisk” (*), “forward slash” (/), “percent” (%), and “caret” (^) symbols are used in formulas. The logical operators help draw relevant conclusions which are used in the decision-making process. Since logical operators return only the Boolean values “true” or “false,” they are also called Boolean operators. Depending on whether the condition matching is true or false, these operators return the output. Likewise, every logical operator Logical Operator In Excel, logical operators, also known as comparison operators, are used to compare two or more values. The “equal to” (=) symbol, used in mathematical operations, helps find whether two values are equal or not. It can also be used for textual data.įor example, if cell C1 contains “rose” and cell D1 contains “lotus,” the formula “=C1>=D1” returns “true.” This is because the first letter “r” is greater than the letter “l.” The values “a” and “z” are considered the lowest and the highest text values respectively. Generally, the “greater than or equal to” operator is used for date and time values and numbers.
0 kommentar(er)
