Excel SIN SINH error

  • I've been writing a few formulas to work out the collision angle for two objects. In these calculations you need to do the SIN and then SINH of an angle. I'm quite dissapointed that excel gives an error with the following;


    =DEGREES(SINH(SIN(RADIANS(-45))))


    excel gives -43.9758368943334 over an degree in error.

    whereas a decent calculator will give -45


    Is there anyway to get around this problem?

  • What calculator are you using that returns -45 for that?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Sorry ignore the minus.


    Essentially what this boils down to is that excel has rounding errors for triganomic functions. It is possible to bypass this with a CORDIC algorithum. But I don't think excel has an add in or anything.

  • Just out of curiosity regarding CORDIC algorithms ...


    You can use them in Mathlab :


    CORDIC Algorithms in MATLAB - MATLAB & Simulink


    and there are several solutions to use Mathlab functions in Excel ...


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!