SIN COS TAN etc.

 
Home
Excel Welcome
Spreadsheet Tutorial
Why on a Computer?
Basics of a Spreadsheet
COLUMN Defined
ROW Defined
CELL Defined
150Data Types
Labels in Excel
Constants in Excel
Formulas in Excel
Basic Formulas in Excel
Change in Formulas
Basic Math Functions
Methods of Selecting Cells
Sum Function
Average Function
Max Function
Min Function
Count Function
CountA Function
IF Function
PMT (loan stuff)
SIN COS TAN etc.
Function Wizard
Copying Formulas
Fill Down
Absolute Positioning
Fill Right
Formatting Text
I P SIN COS TAN etc. N


Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell. If you wanted to find:

 
anglesincostan
REF=sin(REF)=cos(REF)=tan(REF)
00.001.000.00
300.500.870.58
450.710.711.00
901.000.00 
1800.00-1.000.00

format for degrees formula = sin (angle * pi()/180) the argument angle is in degrees
format for radians formula = sin (angle) the argument angle is in radians

To calculate trig functions in degrees you must convert them - otherwise excel will calculate them in radians.

You can type in either an actual number for the REF or you can also type in a reference from the excel spreadsheet (like A2).

1028722


  info@exceltalk.net