![]() 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. |