Spreadsheets: trig functions w/ degrees in LibreOffice Calc

The tutor provides a brief hint about using trig functions of angles in degrees on LibreOffice Calc.

A person who doesn’t use a spreadsheet very often, probably needs it to work quickly and reliably the rare time they do use it.

Let’s imagine you need sin30° from LibreOffice Calc.  Its default setting is radians, rather than degrees. However, you can enter

=sin(radians(30))

Hopefully, you get 0.5 as the answer.

The inner function radians(30) takes the 30 degrees and converts it to radians, which is the calculator’s preference. Then, sin is evaluated.

It’s an easy trick, once you know it.

HTH:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Tagged with: , ,

Leave a Reply