Posted by Bazyle on 26/08/2021 18:20:53:
I've never understood why Excel does trig functions in radians making for an extra calculation instead of providing a straight-up degree option. It must waste millions of man-hours per year around the world.
Well, I suspect the answer is that most of the people designing software in the early days were mathematicians, and so it made sense to make your software that does mathematics do it in a mathematical way. Or, probably more likely, those functions were imported in from a Fortran library, long, long ago and now can't be updated, or everything would break. As an aside, trig functions are calculated in radians, so if you enter anything else it must be converted under the hood anyway.
This may be egg-sucking territory, but Excel has a "named range" functionality, where you can give a grid of cells a name. This grid can be 1×1, and it functions like a programming variable. It is useful for constants like this: you can name a cell "to_radians", say, and then enter your formula as =SIN(90*to_radians).