![]() To solve this task, write the following formula in any cell on the worksheet except A1: A1 E圆: The cell A1 must have data. To solve this task, write the following formula in any cell on the worksheet except A1: A110 Ex5: The cell A1 can contain only values that start from 10 downward. If(A1 Ex4: The cell A1 can contain only values that start from 10 upward. If(A120,Invalid value, ) Ex3: If values in the cell A1 is less than 20, the cell B1 displays Valid value on the contrary, the cell B1 displays Invalid value. If(A1m,Male,) Ex2: If values in the cell A1 is greater than 20, the cell B1 displays Invalid value. To settle the example, you need to write the following formula in the cell B1. If you type m or M in the cell A1, the cell B1 displays Male. When two values are compared by using these operators, the result is a logical value either TRUE or FALSE.Ĭomparison operator Meaning Example (equal sign) Equal to A1B1 (greater than sign) Greater than A1B1 Less than A1 (greater than or equal to sign) Greater than or equal to A1B1 Less than or equal to A1 (not equal to sign) Not equal to A1 B1 The following examples demonstrate each comparison operator.Įx1. Write the following formula: 45 Alternatively, you can write the formula as below: POWER(4,5) II.2.Comparison operators You can use the following operators to compare two values. In Excel, to calculate exponentiation, you use Caret operator or POWER function. Caret () You use caret operator to raise a number to a power.įor example, 34. ![]() You can also use shortcut key to display the value as percentage by pressing ctrl shift. If you type 0.3 in the cell, when you click percent sign in the Number group, Excel displays the value as 30. Percent sign () You use percent sign to display the value of the cell as percentage. Forward slash() You use forward slash to divide numeric values.įor example, divide value1 by value2 and then multiply value3 to the result. Asterisk () Asterisk is used to multiply numeric values.įor example, multiply value1 by value2 and then subtract value3 to the result. Minus sign (-) Minus sign (-) is used to subtract two or more numeric values or represent negative values. ![]() Plus sign () Plus sign () is used to add two or more numeric values. Arithmetic operators The 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. Operators: The (plus sign) operator adds values, and the (asterisk) operator multiplies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |