EXAMPLE - DEGREES and RADIANS Functions

This example illustrates to use the DEGREES and RADIANS functions to convert values from one unit of measure to the other.

Source:

In this example, the source data contains information about a set of isosceles triangles. Each triangle is listed in a separate row, with the listed value as the size of the non-congruent angle in the triangle in degrees.

You must calculate the measurement of all three angles of each isosceles triangle in radians.

Transformation:

You can convert the value for the non-congruent angle to radians using the following:

Single row formula

ROUND(RADIANS(a01), 4)

'r01'

Now, calculate the value in degrees of the remaining two angles, which are congruent. Since the sum of all angles in a triangle is 180, the following formula can be applied to compute the size in degrees of each of these angles:

Single row formula

(180 - a01) / 2

'a02'

Convert the above to radians:

Single row formula

ROUND(RADIANS(a02), 4)

'r02'

Create a second column for the other congruent angle:

Single row formula

ROUND(RADIANS(a02), 4)

'r03'

To check accuracy, you sum all three columns and convert to degrees:

Single row formula

ROUND(RADIANS(a02), 4)

'checksum'

Results:

After you delete the intermediate columns, you see the following results and determine the error in the checksum is acceptable: