Degree sign in excel
When working with mathematical expressions, you periodically need to raise a number to some degree. Conventionally, this can be done in two ways: directly write the number already raised to the power, or put the power sign itself next to it. Most text editors do this as easy as shelling pears, however, in an Excel spreadsheet processor, this seemingly simple action can cause some difficulties for the user. The article will tell you how to place a degree in Excel using the above methods.
Erect through symbol- degree symbol
There are an order of magnitude more ways to raise a number to a power in Excel than just setting the appropriate sign. Let’s start with perhaps the simplest method, which involves the use of the special character “^”. The syntax of a kind of formula is as follows:
where, n is the number to be raised to a power; y is the power to which the number must be raised.
As you can see, the formula is straightforward, and it will not be difficult to remember it. But in order, so to speak, to consolidate knowledge, let’s look at an example where we need to raise the number 3 to the fourth power.
Select the cell where you want to make the calculations.
Use an equal sign (“=”) to tell the program that the formula fits.
Enter the number you want to raise to the power. In this case, 3.
Set the degree symbol “^”. To do this, hold down the Shift key and press the 6 button on the upper digital row.
Enter the degree to which you want to raise the number, that is, 4.
Immediately after that, the result of this mathematical operation will appear in the cell. Now you know how to put a degree in Excel so that the number is immediately raised to it.
USING A FUNCTION – DEGREE
To achieve the desired result, you can also resort to using the function, by the way, it is called appropriately – DEGREE. The way how to put a degree in Excel using a function is not particularly complicated:
In the “Function Wizard” window that appears, find the “DEGREE” line in the list, select it and click OK.
You will see a new window with two input fields. In the first, you need to enter the number that you are going to raise to the power, and in the second directly the power itself. By the way, instead of a number, you can specify a cell with a numerical expression, then it will be raised to a power.
Now you know the second way, how to put a degree in Excel, but what if you do not need to raise a number, but simply indicate its degree in text format? In this case, go to the third method.
If you want to indicate the degree of a number directly in a cell, then you must use a superscript. In fact, the execution of such a recording is not extremely difficult, just the algorithm of action for this is not entirely clear to an ordinary user, because before the recording itself, some more preparation will need to be done. But first things first. Let’s look at everything with an example so that it is immediately clear how it works.
Change its format to text. To do this, being on the main tab, on the toolbar, click on the drop-down list located in the “Number” group.
Now everything is ready for the entry in the cell to be displayed correctly. So, put in the number 34. Why him? Because 4 is a power of 3, which we are going to modify now.
Press Ctrl + 1 hotkeys on the keyboard.
The Format Cells window appears. In it, you need to set a check mark opposite the “Superscript” item in the “Modify” area.
Now you know three ways to work with a degree in Excel. Two of them imply direct raising to a given power, which is very convenient for calculations.