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.

Participate now!

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