+0  
 
0
1179
4
avatar+90 

So for the past few hours I have tried to translate the equation pictured below into MS Excel ( I am using the Danish version), this is what I have gotten so far: ''=(Tan(RADIANER(C4)*(C8*0,5))/(Sin(RADIANER(arctan(RADIANER(Tan(RADIANER(C4)*(C8*0,5)))/((C8/3)*0,5)))))))''


Can anyone help? 

 

Sincerely

 

Jonas P. 

 

 Apr 25, 2017
 #1
avatar+118608 
+3

Hi 

My Excel is the English version ..      

Oh that answer formula should be    B5/B7

 

 Apr 25, 2017
edited by Melody  Apr 25, 2017
edited by Melody  Apr 25, 2017
 #2
avatar+90 
+1

Thanks, will use this if all else fails, trying to get it into just one cell, as the project this equation relates to specifies that we have to use the least amount of calculations possible. But thanks again, was afraid that the question would get lost to the ages. 

Sincerely

 

Jonas P. 

 Apr 25, 2017
 #3
avatar+118608 
+2

This is very easy to put into one cell.

I just separated it to make it easier to follow :)

Melody  Apr 26, 2017
 #4
avatar+90 
0

Yea, it should be easy, but apparently Excel won't allow it.
This is really starting to p**s me off. 
 

Thanks for the help anyways. 

Sincerely 

 

Jonas Pedesk

 Apr 26, 2017

3 Online Users