Microsoft KB Archive/22767

Multiplan: How to Get Other Trigonometric Functions PSS ID Number: Q22767 Article last modified on 10-08-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Microsoft Multiplan does not have any explicit secant, cosecant, cotangent, or inverse functions, but you can enter the formulas to obtain them. The following formulas should work correctly; however, keep in mind that the these formulas use an angle a, measured in radians:

cosecant CSC(a)= 1/SIN(a) secant SEC(a)= 1/COS(a) cotangent COT(a)= 1/TAN(a)

arctangent ATAN(a)=ATAN(a) arccosine ACOS(a)= (PI/2) - ATAN(a/(SQRT(1-(aa)))) arcsecant ASEC(a)= ATAN(a/(SQRT(1-(aa))))

These formulas can be expressed in other forms; any mathematical reference book should be able to provide these.

In Multiplan version 4.20, the following trigonometric functions were introduced:

ACOS(a) - Returns the arccosine (in radians) of number ASIN(a) - Returns the arcsine (in radians) of number ATAN(a) - Returns the arctangent (in radians) of number ATAN2(x-number, y-number)- Returns the arctangent (in radians) of the x and y coordinates represented by x-number and y-number

Copyright Microsoft Corporation 1990.