Then in parentheses, specify the required parameters: two numbers separated by a semicolon. Or you can continue to write, manually enter each letter. As soon as you saw such a hint, just press the "Tab" key.Usually it is enough to write «=po…» - and the system itself will guess to offer you a useful option. In the formula line we put the sign "=" and begin to enter the name of the function.If you think that extra clicks are a dubious pleasure, we offer one simpler variant. The program has calculated everything correctly and has given you the result.
For this situation, it is "2" in the "cube", i.e.
Press the "OK" button and get in the cell into which the formula was entered, the value we need. Then in the first field enter "2", and in the second - "3". For example, we need to exponentiate "2" to the degree of "3". In the dialog that appears, fill in the fields with arguments. Or select: «FORMULAS»-«Function Library»-«Math & Trig»-«POWER». From the «Or select a category:» drop-down list, select «Math & Trig», and in the bottom field «Select a function:», specify the function «POWER» we need and click OK. Start the function wizard by using the hotkey combination SHIFT + F3 or click on the button at the beginning of the formula line "fx" (insert function). Formula for the exponentiation in Excel The values of both parameters can be less than zero ( with a "-" sign). This is an indicator in which we build the first figure. The second figure is the value of «degree». Microsoft Office Excel allows the introduction of any real number. This is the basis (that is, the figure that we are building). The first digit is the value «number». The numbers for this formula are indicated without spaces or other signs. 
In Microsoft Office Excel there is a convenient function «POWER», which you can activate for simple and complex mathematical calculations We built 8 into a "square" (that is, to the second degree) and got the result of the calculation in cell "A2".
The degree is indicated after the sign "^". In order for the number to be exponentiation to the required degree, it is necessary to put the "=" sign in the cell before specifying the number you want to build. The standard and easiest option is to use the "^" icon, which is obtained by pressing Shift + 6 with the English keyboard layout. Any value of "A" in the power of "1" will be equal to "A".Įxamples in Excel: Variant 1. 
Any number raised to zero degree equals one.Before searching for the required function, pay attention to the mathematical laws:
0 kommentar(er)
