Apache OpenOffice (AOO) Bugzilla – Issue 18492
ASIN() function does not calculate correctly.
Last modified: 2003-09-08 16:55:29 UTC
ASIN() function does not work at 0.221. ASIN(0.221)=12.77 is the correct result, but answer you get is what you input. function seems to work at values closer to -1 and 1.
Hi Philip, this is not a bug ! The result of an trigonometric function like ASIN will be in radians. So if you need degrees, just place a degrees in front of the ASIN so your formula looks like this : =DEGREES(ASIN((B31-B29)/B31)) Best regards Frank
closed invalid
Grrr, forgot to set the closed button.