search

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

negative sign placed at beginning of line instead of in front of modified expression #98

Open benmccann opened 2 years ago

benmccann commented 2 years ago

I have the formula:

=IF(AB$5=$C$6,(1+$C$18)*(-$H$4-$H$5),IF(AND(AB$5>$C$6,AB$5<$BF32,AB$5<=$AJ$5),-$H$4*$H$6/4,0)+IF(AB$5=IF($BF32>$AJ$5,$AJ$5,$BF32),$V32,0)+IF(AB$5=$BF32,MIN($U32,MAX(0,MAX(0,-SUM($X32:AA32))+(1-incentiveFee)*(nonRecourse+returnPercentage*($U32-nonRecourse)+SUM($X32:AA32)))),0))

Part of the output is:

 -                    SUM(
                        $X32:AA32
                    )

Which would be easier to read as:

                    - SUM(
                        $X32:AA32
                    )
leonardloo commented 1 year ago

@benmccann I'm the co-founder of Voltade.com, which converts Excel formulas into APIs in a few clicks. Thought this might be relevant to you too!