“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

So i have a large number of x and y points i need the arctan(y/x) of each point to graph it. I want to know how to write the formula so that it will give each point, without having to write arctan(y1/x1), arctan(y2/x2).... and so on

Solved by M. C. in 29 mins

Hi, I am a student carrying out work with assessing weather data and have 4000+rows of data that need formula applied to the. The formula that needs to be applied is dependent on the magnitude of the values for x and y. i.e for: x> apply arctan y/x y>=0,x<0 appply arctan y/x +pi y<0,x<0 apply arctan y/x -pi y>0,x=0 apply +pi/2 y<0,x=0 apply -pi/2 y=0,x=0 apply undefined is there any way of doing this that does't require going through them one by one? Any help greatly appreciated. Regards, Matthew

Solved by O. U. in 24 mins

i need help in dates in excel , how to count dates in excel ,

Solved by S. E. in 20 mins

In Microsoft excel, what is Survival analysis test in Microsoft excel. Must have a strong actuarial and Microsoft excel command.

Solved by D. D. in 26 mins

I can only open Excel in the Excel software. When I'm in "search documents" and I click on Excel it opens Excel with no document attached.

Solved by X. F. in 17 mins