Home

How to Convert degrees to radians with Excel's trig functions

Apr 14, 2010 09:41 PM

Spreadsheet showing a conversion table between degrees and radians.

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degrees and radians in Excel with trigonometric functions and formulas. Rad!

The relevant formulae are as follows:

Radians = degrees*PI()/180

The PI () function will give you p up to 15 digits.

The RADIANS function converts degrees to Radians.

The DEGREE function converts radians to degrees.

Radians*180/PI() = degrees

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.