Hello, I just joined you. I want your help for the formula below. Please don't refuse.

How can I insert the formula in the link into Excel? I have thousands of data. It takes me months to do them one by one with a calculator.

for example

a: 0.66

b: 0.48

olesore Dec 5, 2020

#1**+1 **

Hi olesore,

Welcome to our web2.0 forum!

atan is the same as tan^(-1)

Excel defaults to radians so that is why i have multiplied the result by 180/pi

Can you work it out now?

---------------------------------------------------------------------------------------------------------------------

I double checked it by finding tan^(-1) (1/sqrt3) which I know is 30 degrees.

Melody Dec 5, 2020

#2

#3**+2 **

You are welcome.

Maybe you are a bit lucky too.

I do not remember seeing anyone else answer Excel questions on here.

(Although there must be a handful of people here who could)

Is that all you want? Did you want to know how to round it off to the nearest degree, or anything like that?

Also you could include pi in the equation. Just replace B5 with PI() that would be more straight forward.

Melody
Dec 6, 2020