Excel question.

  • Thread starter Thread starter NRENNIE
  • Start date Start date
N

NRENNIE

Hi,

I'm trying to do a formula in Excel that has me stumped. Would appreciate a
bit of help.
I have the formula:
=((C43*TAN(G29*PI()/180))/C45)
Which in this case gives the figure:
0.429608961
I want the inverse tangent (inv tan) of this figure, which when worked out
on a calculator is:
23.2487

Does anyone know what I should add to the formula to get the 23.2487 figure?


Thanks,

Nick
 
I want the inverse tangent (inv tan) of this figure...

Hi. Try either:
=ATAN(0.429608961)*180/PI()
or
=DEGREES(ATAN(0.429608961))
 
Check your other post.
Hi,

I'm trying to do a formula in Excel that has me stumped. Would appreciate a
bit of help.
I have the formula:
=((C43*TAN(G29*PI()/180))/C45)
Which in this case gives the figure:
0.429608961
I want the inverse tangent (inv tan) of this figure, which when worked out
on a calculator is:
23.2487

Does anyone know what I should add to the formula to get the 23.2487 figure?

Thanks,

Nick
Click to expand...
 
Back
Top