Manuals/calci/tan

Revision as of 05:30, 28 November 2013 by Abin (talk | contribs) (→‎Examples)
TAN(n)


  • where n is in Radians
  • by default Calci use Radian as angle

DTAN can be used if the angle is in degrees.

The angle can be a single value or any complex array of values. TAN= SIN / COS


For example TAN(1..100) can give an array of the results, which is the TAN value for each of the elements in the array. The array could be of any shape.

Description

Consider     n = 90    then     =TAN(RADIANS(90))    gives    1

  • TAN function determines the sine of the given angle.

Examples

  1. Example 1
Spreadsheet
A B C D E
1 5 7 8
2 7 4
3 8
4 4 -5 9
5

From the above table values:

=MMULT(3,A1:A3)
15 21 24
=MMULT(6,A4:C4)
24 -30 54
  1. Example 2
Matrix A
7 5
2 3
6 0
9 8
Matrix B
8 -4 11
2 7 5




α cell2
Matrix A
7 5
2 3
6 0
9 8
the original table again
Matrix B
8 -4 11
2 7 5
B B
C
D












  • Here Matrix A is of order 4x2 and Matrix B is of order 2x3.
  • So the Product Matrix is of order 4x3. i.e
  1. 1st Row 7*8+5*2 = 66 ; 7*(-4)+5*7 = 7 ; 7*11+5*5 = 102
  2. 2nd Row 2*8+3*2 = 22 ; 2*(-4)+3*7 = 13 ; 2*11+3*5 = 37 and so on