Excel question.

[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

 

[Dana DeLouis]

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

Hi. Try either:
=ATAN(0.429608961)*180/PI()
or
=DEGREES(ATAN(0.429608961))

 

[Dave Peterson]

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