Appendix 376
Trigonometric Functions
The arguments for trigonometric functions are either numbers, field names, or
addresses of cells that contain numbers. The results of these calculations are
always numbers.
Function
Description
Example
ACOS
(value)
Returns the angle that is the
arccosine
of a
value from -1 to 1. Value can be a cell or field
reference.
=ACOS(.50)
returns
1.047198 radians.
ACOSH
(value)
Returns the angle that is the
hyperbolic
arccosine
of a value. The inverse hyperbolic
cosine is the number for which the hyperbolic
cosine is
value
.
Value
must be equal to or
greater than 1.
=ACOSH(5)
returns
2.292432.
ASIN
(value)
Returns the angle that is the
arcsine
of a value.
The arcsine is the angle which is the sine of
value
. The angle is between
π
2 and
−π
2 radians.
Value
must be from -1 to 1.
=ASIN(.75)
returns
0.848062 radians.
ASINH
(value)
Returns the angle that is the
hyperbolic
arcsine
of a value. The inverse hyperbolic sine
is the number which is the hyperbolic cosine of
value
.
=ASINH(10)
returns
2.998223.
=ASINH(15)
returns
3.402307.
ATAN
(value)
Returns the angle that is the
arctangent
of a
number. The arctangent is the angle (in radians)
for which the tangent equals
value
.
Value
is the
tangent of the angle you want.
=ATAN(90)
returns
1.559686 radians.
ATANH
(value)
Returns the angle that is the
hyperbolic
arctangent
of a value.
Value
must be between
(but not including) -1 and 1. The inverse
hyperbolic tangent is the number which is the
hyperbolic tangent of
value
.
=ATANH(0.75)
returns
0.972955.
ATAN2
(value)
Returns the
arctangent of the angle
determined by the coordinates(x,y)
. The
arctangent is the angle formed by the x-axis and
a line passing through the origin (0,0) and the
specified
x,y
coordinate. The coordinates
x,y
can be in any quadrant. The angle is returned in
radians from
π
2 to -
π
2. A positive result
indicates a counterclockwise angle from the
x-axis. You cannot use the origin for the
x,y
argument. If you use 0,0 for
x,y
, the #VALUE#
error appears in the cell.
=ATAN2(1.5,2.0)
returns
0.643501 radians.
angle
y
x
(x,y)
ATAN2
Содержание Ensemble PDP-100J
Страница 11: ......
Страница 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Страница 72: ......
Страница 83: ......
Страница 84: ...Word Processing 71 3 Word Processing Important Word Processing Tips ENTER ENTER TAB SPACEBAR TAB ...
Страница 152: ......
Страница 217: ...Spreadsheet 203 The following dialog box appears ...
Страница 219: ......
Страница 262: ......
Страница 269: ......
Страница 284: ......
Страница 301: ......
Страница 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Страница 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Страница 312: ......
Страница 325: ......
Страница 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Страница 329: ...Book Reader 308 Printing from Book Reader To print selected text from a book To print the current page ...
Страница 330: ......
Страница 333: ......
Страница 337: ...Text File Editor 314 ...
Страница 338: ......
Страница 345: ......
Страница 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Страница 350: ......
Страница 379: ......
Страница 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Страница 396: ...Appendix 369 Print Functions Function Description Example ...
Страница 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Страница 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Страница 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Страница 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Страница 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Страница 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Страница 411: ...Appendix 384 URW SymbolsPS Font Bracket keyboard Greek keyboard Symbol Math keyboard Symbol Other keyboard ...
Страница 414: ......
Страница 418: ...Glossary 390 ...
Страница 420: ...Glossary 392 0 1 1 1 ...
Страница 421: ...Glossary 393 text style sheet ...
Страница 422: ...Glossary 394 ...
Страница 423: ......
Страница 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Страница 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Страница 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Страница 440: ......