joshbtn / excelFormulaUtilitiesJS

This library contains methods to beautify an excel formula. This library also contains functions to convert an excel formula to JavaScript (ECMAScript) or C# and python.
http://excelformulabeautifier.com/
Other
394 stars 101 forks source link

If, c#, and js #64

Closed jimlynnjulian closed 6 years ago

jimlynnjulian commented 7 years ago

The software ignores Excel formula 'if' statements. There's no difference between the C# and Javascript conversions.

AD2=DEGREES(ACOS(SIN(RADIANS($B$3))SIN(RADIANS(T2))+COS(RADIANS($B$3))COS(RADIANS(T2))*COS(RADIANS(AC2))))

and

AF2=Atmospheric refraction in degrees =IF(AE2>85,0,IF(AE2>5,58.1/TAN(RADIANS(AE2))-0.07/POWER(TAN(RADIANS(AE2)),3)+0.000086/POWER(TAN(RADIANS(AE2)),5),IF(AE2>-0.575,1735+AE2(-518.2+AE2(103.4+AE2(-12.79+AE20.711))),-20.772/TAN(RADIANS(AE2)))))/3600