This FAQ covers 3 common issue types for the DEGREES function: parameter errors, unexpected results, and batch filling; it includes 3 common questions.
FAQ
What should I do if the DEGREES function returns #VALUE!?
- Check whether the parameter is a value that can be calculated.
- Make sure the source cell does not contain extra spaces or text characters.
- Clean the source data if needed, then enter the formula again.
Why does the DEGREES result look different from what I expected?
- Confirm that the referenced cell is correct.
- Check whether the source value is in radians rather than a value that has already been converted to degrees.
- Review the formula parameter and the cell format so the result is displayed as a number.
How can I use the DEGREES function in multiple cells at once?
- Enter the DEGREES formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag downward or copy and paste the formula into the target range, then confirm that the cell references behave as expected.
Glossary
| Term | Definition |
|---|---|
| Radian | A way to measure angles. The DEGREES function converts this value into degrees. |
| Degree | The converted result returned by the function, usually easier to read in reports and worksheets. |
| Function argument | The input inside the function parentheses. DEGREES requires one angle argument. |