excelFormulaUtilitiesJS icon indicating copy to clipboard operation
excelFormulaUtilitiesJS copied to clipboard

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

Open benmccann opened this issue 3 years ago • 1 comments

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
                    )

benmccann avatar Apr 14 '22 19:04 benmccann

@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!

leonardloo avatar Apr 15 '23 10:04 leonardloo