+0  
 
0
177
4
avatar+77 

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. 

 

SomeoneSomewhere  Apr 25, 2017
Sort: 

4+0 Answers

 #1
avatar+91239 
+3

Hi 

My Excel is the English version ..      

Oh that answer formula should be    B5/B7

 

Melody  Apr 25, 2017
edited by Melody  Apr 25, 2017
edited by Melody  Apr 25, 2017
 #2
avatar+77 
+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. 

SomeoneSomewhere  Apr 25, 2017
 #3
avatar+91239 
+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+77 
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

SomeoneSomewhere  Apr 26, 2017

4 Online Users

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.  See details