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

Hello I am trying to convert a written formula into Excel but not having much joy! Please see below, is there anything obvious that I am missing? =(F$2/sq(F$3^2+10^4*pi^2*F$4^2))*sin(100*pi*A2-tan^-1(100*pi*F$4/F$3)) Your help would be greatly received :)

Solved by O. S. in 28 mins

how do i use pi in excels developer tab?

Solved by A. S. in 12 mins

In an excel work book I have a (large number of) dynamic formula linked to Pi, vlookup and standard calculation formulas in another worksheet(s). Using the calculation options in the formulas menu I can update all the worksheets individually except the sheet that contains the dynamic links (approximately 600). Excel crashes at this point. How do I get this tab to calculate without crashing?

Solved by C. C. in 14 mins

i cant calculate sin(20*pi*0) 0-80 i need some assistants

Solved by A. F. in 20 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