Forum Discussion

Lorenzo_Masotti_arch's avatar
Lorenzo_Masotti_arch
Copper Contributor
Jun 07, 2023

Modify standard Excel calculation of SEN, COS, TAN from Radiant to Degrees

Hi there! Is there in Excel 2021 an option to change the Excel format option that requires to calculate normally SEN, COS, TAN in rad and change it in radiant?

excel
Formulas and Functions

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 07, 2023

    Lorenzo_Masotti_arch 

    In Excel, the trigonometric functions such as SIN, COS, and TAN are calculated using radians by default. However, you can convert the angle from radians to degrees by using the RADIANS and DEGREES functions in Excel.

    To calculate the trigonometric functions in degrees, you can follow these steps:

    1. Convert the angle from degrees to radians using the RADIANS function. For example, if the angle is in cell A1, you can use the formula "=RADIANS(A1)" to convert it to radians.
    2. Apply the trigonometric function (SIN, COS, TAN) to the converted angle.
    3. If you want the result to be in degrees, you can then use the DEGREES function to convert it back. For example, if you have the result of SIN in cell B1, you can use the formula "=DEGREES(B1)" to convert it to degrees.

    Here is an example:

    1. Let's say you have an angle in degrees in cell A1. To calculate the sine of the angle in degrees, you can use the formula "=SIN(RADIANS(A1))".
    2. To calculate the cosine of the angle in degrees, you can use the formula "=COS(RADIANS(A1))".
    3. To calculate the tangent of the angle in degrees, you can use the formula "=TAN(RADIANS(A1))".

    By using the RADIANS and DEGREES functions, you can modify the standard Excel calculation of SIN, COS, and TAN from radians to degrees.

Resources