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

=SQRT(((2*SIN(D4))/(SQRT(3))+0.5)^2+0.75)
This is the formula that i want to put in but doesn't let me, is there something wrong? (D4=1,16875)

Solved by A. A. in 17 mins

i want to appy '=ASIN(SQRT(' to a set of cells and cannot work out how? Its 225 cells and it would take me all night to do them individually

Solved by G. H. in 11 mins

I need to put an error propagation formula into excel and it is not working. This is what I've entered ABS([@d])*SQRT{.0000000313+[129600/(32400-[@[Mass(m)]]^2)]*[.01+(8100/[@[Mass(m)]]^2)*.01]}

Solved by K. H. in 24 mins

=(SQRT(D5) - ((D12 + G8)/180))^2
I need to put 20 copies of the above formula in to one column (no gaps) while keeping relative addressing for the D cells but keeping the reference to G8 fixed - can it be done?

Solved by G. J. in 19 mins

I am trying to do a standard error for my data =stdev(cell)/(sqrt(number of samples)). However it keeps coming up with #DIV/0! even though none of the numbers are 0, so nothing is being divided by 0? I have tried entering the values manually rather than clicking on the required cells too but even that is giving the same issue.

Solved by X. H. in 14 mins