# trig problems in excel, cant get tan function working

Discussion in 'Homework Help' started by ninjaman, Jun 12, 2016.

1. ### ninjaman Thread Starter Member

May 18, 2013
306
1
Hello,

I am trying to answer a book question in excel,
draw the following graph:

y = 2 tan(theta+60degrees) for 0 < theta < 360

I have tried converting to degrees and using the degree() function and I am not getting the result shown in the answers section.

I use the asterisk in between 2 * tan, not sure what I am doing wrong here.

Thanks

2. ### WBahn Moderator

Mar 31, 2012
18,085
4,917
What, exactly, is the function you've typed in to the cell?

The tan() function requires an argument in radians, not degrees. The degrees() function (I'm not aware of a degree() function) converts an argument in radians to degrees. You need to do the opposite and convert an argument in degrees to radians. Take a guess what that function is called.

May 18, 2013
306
1

4. ### WBahn Moderator

Mar 31, 2012
18,085
4,917
Close. If the function to convert to degrees is called "degrees()" (not "degree()"), then the function to convert to radians wouldn't be called "radian()", it would be called _____?

5. ### WBahn Moderator

Mar 31, 2012
18,085
4,917
Oh, and one thing to watch out for is that the tan() function goes singular (i.e., to infinity) when it's argument is either 90° or 270°.

6. ### DGElder Member

Apr 3, 2016
347
87
or convert degrees to radians by multiplying the degrees by PI()/180