joshbtn / excelFormulaUtilitiesJS

Based on ewbi's go calc excel formula parser http://ewbi.blogs.com/develops/popular/excelformulaparsing.html. 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

User Error #68

Closed MarioForm closed 6 years ago

MarioForm commented 6 years ago

Working with some horrible excel functions that are nested conditionals and the like. Was wondering if this is something that could be handled better.

Formula:

=IF(Calculations!F5=TRUE,(((((D60D60(F51(PI()/180)))/2)-((((SIN(F51((PI()/180))/2)))D60)(SQRT((D60D60)-((((SIN(F51((PI()/180))/2)))D60)(((SIN(F51((PI()/180))/2)))D60))))))+(D59D57))/(144))+(D43D44)/144,((((D60D60(F51(PI()/180)))/2)-((((SIN(F51((PI()/180))/2)))D60)(SQRT((D60D60)-((((SIN(F51((PI()/180))/2)))D60)(((SIN(F51((PI()/180))/2)))D60))))))+(D59*D57))/(144))

Output sample:

sample

Maybe I am inputting incorrectly, or could make the input look better before trying to make it look pretty. Let me know if that is the case!