excelFormulaUtilitiesJS
excelFormulaUtilitiesJS copied to clipboard
negative sign placed at beginning of line instead of in front of modified expression
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 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!