Data Validation with Trigonometric Function (Powered with the IF function)

Data Validation with Trigonometric Function (Powered with the IF function)

In this tutorial you are going to learn how to make data validation which will create a drop down list for the following: sine, cosine and tangent.
Then we are going to use the if function to determine the result.

In this case, there are three possibilities so we are going to have two if function and one false.

Step 1:

On cell A1 type Trig. Function

On cell B1 type Number

On cell C2 type answer

Step 2

Click on Cell A2 click the Data tab>>> Data Validation

Under validation criteria click select List under source type Sine,Cosine,Tangent. (This should be typed and separated by a comma). Click Ok

Step 3

Move to cell C2

Type the following into the formula or copy and paste this one

=IF(A2="Sine",SIN(RADIANS(B2)),IF(A2="Cosine",COS(RADIANS(B2)),TAN(RADIANS(B2))))

If you want to find a particular trig function select from the list, type the number and you will see how this works.

Example1:  lets find Sine 60 from the list

Example 2: Cos 25

Example 3: Tangent 45

I believe this is pretty cool. After the steps just enter the value and change the type of trigonometric function Excel will do the rest for you.