ExcelBanter - degrees formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - degrees formula (https://www.excelbanter.com/excel-worksheet-functions/66686-degrees-formula.html)

on a calculator I would
divide the smaller number by the larger number and then inv tan to get
the degrees
what is the simplest way to get the degrees from a spreadsheet formula,
I have found one way, by getting the two numbers and using radians and
soforth and finally getting my degrees after a couple of steps, there
should be a way to just take the two numbers and formulate degrees
from them

...there
should be a way to just take the two numbers and formulate degrees
from them

Not sure, but is this what you need?

=DEGREES(ATAN2(A1,B1))

HTH. :)
--
Dana DeLouis
Win XP & Office 2003

"damorrison" wrote in message
oups.com...
on a calculator I would
divide the smaller number by the larger number and then inv tan to get
the degrees
what is the simplest way to get the degrees from a spreadsheet formula,
I have found one way, by getting the two numbers and using radians and
soforth and finally getting my degrees after a couple of steps, there
should be a way to just take the two numbers and formulate degrees
from them

yes this does work, thanks
Dave