Skip to content
This repository was archived by the owner on Dec 6, 2025. It is now read-only.
This repository was archived by the owner on Dec 6, 2025. It is now read-only.

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

@benmccann

Description

@benmccann

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
                    )

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions