LiveCode Forums.

Posted: **Fri Apr 19, 2013 4:11 am**

Hello,
I'm trying to change this code:

MOD(DEGREES(ACOS(((SIN(RADIANS(B3))*COS(RADIANS(AD2)))-SIN(RADIANS(T2)))/(COS(RADIANS(B3))*SIN(RADIANS(AD2)))))+180,360)

Into an LC function.

When I thought I had it right the results wouldn't match up to Excels results.

Any help welcome.
Thank you,
Simon

Posted: **Fri Apr 19, 2013 9:12 pm**

Just thought I'd bump this message.

Thanks,
Simon

Posted: **Sat Apr 20, 2013 5:29 am**

Got It!

Code: Select all

Excel
MOD(DEGREES(ACOS(((SIN(RADIANS(B3))*COS(RADIANS(AD2)))-SIN(RADIANS(T2)))/(COS(RADIANS(B3))*SIN(RADIANS(AD2)))))+180,360)
In LC becomes
((ACOS(((SIN((B3)*pi/180)*COS((AD2)*pi/180))-SIN((T2)*pi/180))/(COS((B3)*pi/180)*SIN((AD2)*pi/180))))*180/pi +180 MOD 360)

Too much over thinking, it really was almost a cut and paste.

Simon

LiveCode Forums.

Converting Excel formula into LC

Converting Excel formula into LC

Re: Converting Excel formula into LC

Re: Converting Excel formula into LC