EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel DEGREES Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel DEGREES Function

By Madhuri ThakurMadhuri Thakur

Excel DEGREES Function

DEGREES Function in Excel (Table of Contents)

  • Introduction to DEGREES Function
  • How to Use DEGREES Function in Excel?

Introduction to DEGREES Function

The degrees function in Excel is one of the simplest functions to be used. It belongs to the category of “Math and Trigonometry function” in Excel. The function converts an angle value, which it takes as a parameter, from radians to degrees. The function was introduced in MS Excel 2000 edition. The function proves handy in situations that require the use of angle values presented in degrees. The function has a very simple syntax which is as shown below.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Syntax: 

DEGREES Syntax

Here, the angle is represented in radians, and the DEGREES function successfully converts it into corresponding degree values.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,325 ratings)

How to Use DEGREES Function in Excel?

The mathematical relation between two units of angle that we saw in the above section does allow us to determine value in degrees for any angle value. However, Excel provides us DEGREES function using which we can easily find the corresponding value in degrees. The following section shows the implementation of the DEGREES function in Excel. Let’s go through the following steps.

You can download this Excel DEGREES Function Template here – Excel DEGREES Function Template

We have a table containing angle values. We intend to convert these values from radians to degrees. First, have a look at the data. On the left-hand side column, we have four angle values represented in radians, and on the right-hand side, we have angle values presented in degrees.

Excel DEGREES Function 1-1

As we intend to convert these values from radians to degrees, we shall implement the DEGREES function. When we start typing the name of the function, Excel automatically pops up the names of all the functions for which the names start from D. We can select the DEGREES function by moving to using arrow keys or by just clicking on it. As we can see, the function description reads, “Converts radians to degrees”. So, Excel helps us to understand the DEGREES function by providing the most appropriate definition.

Excel DEGREES Function 1-2

When we type the opening bracket, Excel highlights the function’s argument to perform its function. Here, in the case of the DEGREES function, we have only one argument, which is the angle. Go through the following screenshot.

Excel DEGREES Function 1-3

We passed the value as illustrated in the below screenshot to convert the corresponding angle from radians to degrees. As we can see, we passed the cell containing the requisite angle value in radians as the parameter in the DEGREES function.

Excel DEGREES Function 1-4

Now, observe the result that we got, as can be seen in the following table. As we can see, the DEGREES function has given us the correct result, i.e. 90. So, this means that 1.57080 radians are equal to 90 degrees. In a similar way, we shall convert other angle values also from radians to degrees.

Excel DEGREES Function 1-5

We just copied the function down across all the required cells and got correct conversions of angle values from radians to degrees. The following table shows the angle values in radians and the corresponding angle values in degrees obtained using the DEGREES function. Likewise, we can convert any angle value from radians to degrees.

DEGREES Function 1-6

The formula implemented in the above table is as follows. Go through the table and see how the DEGREES function takes the argument.

DEGREES Function 1-7

In the earlier part, we saw the importance of ∏ in conversion of angle from radians to degrees. In Excel, we have a function which is called PI(). This function gives a constant value, i.e. 3.14159. We can work with the DEGREES function using this function also. Let’s see this as illustrated below.

angle of radian 2-1

After using PI Formula, the output shown below.

angle of radian 2-2

Using DEGREES Function in cell A2.

angle of radian 2-3

After using the above formula, the output is shown below.

angle of radian 2-4

We can see how the PI() function can be passed as a parameter into the DEGREES function through the above screenshot. Using the PI() function, we can avoid the direct use of direct values. The PI() function can be divided as a suitable constant and then can be passed as a parameter in the DEGREES function. So, there are various ways to work with and use the DEGREES function, and the best-suited method should be employed for use.

We can also pass a negative value in the DEGREES function. Negative angles just indicate a different direction of the way in which angles are measured. The following table shows how the DEGREES function returned the appropriate values for the negative angles too.

Negative values 3-1

Negative values 3-2

Negative values 3-3

Converting Radians to Degrees

We will see the basics of angle conversion from radians to degrees.

  • In geometry, radians and degrees represent the units, i.e. various ways of representing the measurement of the angle, which is subtended at the center of the circle by an arc. In order to understand how the conversion from radians to degrees happens for angles, we must know the relation between the two units. The relation can be written as shown below.

∏ radians = 180 degrees

  • ∏ is a constant which has a value of 3.14159. So 180 degrees amount to 3.14159 radians. Using this relation, we can calculate a value in degrees for any angle which is represented in radians. So, we have 1 radian equal to about 57.3 degrees. And if we want to find value for 270 degrees, the formula shall be (3.14159 X 270) / 180. The value thus obtained would be in degrees. This formula can be written as (∏ X 270)/180.

Things to Remember About Excel DEGREES Function

  • While Excel provides a self-explanatory approach for the use of its every functionality and the implementation of the DEGREES function is easy.
  • Valid parameters must be passed into the function, or else, the function shall return an error.
  • Though the function looks simple, it is a context-based function used in situations involving complex mathematical problems and calculations.
  • In such cases, amongst all the options available, the DEGREES function is the best one.

Recommended Articles

This has been a guide to Excel DEGREES Function. Here we discuss how to use Excel DEGREES Function along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Text with Formula
  2. Excel Sum Time
  3. Logical Functions in Excel
  4. COS Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Excel DEGREES Function Template

EDUCBA

Download Excel DEGREES Function Template

EDUCBA

डाउनलोड Excel DEGREES Function Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more