Functions and their Charts

[Ana]

Hi. In Excel it would be great to have sample charts of common functions
(e.g.: SIN, COS, LN, LOG, etc.).

 

[Bernard Liengme]

In A1 and B1 enter heading such as X and Sin(X)
In columns A put a series of X values
In B2 use =SIN(A2) (or =LN(A2)); copy down the column and chart

Hold it! Did I tell you Excel's trig expects radians (the only REAL way to
measure angles)
So if you x-values are degrees we nee =SIN(RADIANS(A2)

best wishes

 

[Jon Peltier]

Bernard -

the only REAL way to measure angles

Sure, first you push Celsius and meters and stuff on us, now radians!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______