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
    17,716
    4,788
    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.
     
  3. ninjaman

    Thread Starter Member

    May 18, 2013
    306
    1
    is it radian() fucntion?
     
  4. WBahn

    Moderator

    Mar 31, 2012
    17,716
    4,788
    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
    17,716
    4,788
    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
    344
    85
    or convert degrees to radians by multiplying the degrees by PI()/180
     
Loading...