Chronology Current Month Current Thread Current Date
[Year List] [Month List (current year)] [Date Index] [Thread Index] [Thread Prev] [Thread Next] [Date Prev] [Date Next]

Re: sine and QPro



Dwight,

One way to use degrees in a spreadsheet is to convert them
to radians within the cosine or sine function. In Works,
pi() (this is pi with empty parenthesis) is pi, so use pi
radians per 180 degrees to convert. An example
spreadsheet follows. I hope the tab stops come through
OK.

A B C
1 deg formula answer
2 0 =cos(pi()/180*a2) 1
3 45 =cos(pi()/180*a3) 0.7071
4 90 =cos(pi()/180*a4) 0
5 135 =cos(pi()/180*a5) -0.7071
6 180 =cos(pi()/180*a6) -1

rac