G Guest Oct 10, 2004 #1 Hi. In Excel it would be great to have sample charts of common functions (e.g.: SIN, COS, LN, LOG, etc.).
Hi. In Excel it would be great to have sample charts of common functions (e.g.: SIN, COS, LN, LOG, etc.).
B Bernard Liengme Oct 11, 2004 #2 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
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
J Jon Peltier Oct 13, 2004 #3 Bernard - the only REAL way to measure angles Click to expand... 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/ _______
Bernard - the only REAL way to measure angles Click to expand... 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/ _______