How to write a number to the degree in Excel? Here you need to use the Format Cells tab. It is often important for you that the number in the degree is correctly displayed when printing and looks beautiful in the table. How to write a number to the degree in Excel? In the arguments of a formula and a function, you can specify cell references instead of the numbers. In Excel, you should write through this formula: = 32 ^ (1/5), that is: = a ^ (1 / n) - where a is a number N-degree: "A root of n-th degree from the number a will be equal to raising to the degree of the same number a by 1/ n", that is:įrom this it follows that to calculate the mathematical formula of the root in the n-th degree for example: "A root of the n-th degree of a is a number b whose n-th degree is equal to a", that is: Let us recall the theory from mathematics: In the cell, the figure obtained as a result of the mathematical calculation of the root will be reflected.ĪTTENTION! If we need to know the root of the degree in Excel then we do not use the function =SQRT().
After entering the number, just click on the "OK" button. In our case, it was necessary to find the root from "25", so we enter it into the line.
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).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)
