Skip to content

Major bug on Rollup sheet column O #1

@HPCguy

Description

@HPCguy

You have the following formula in column O of the Rollup sheet in the ods file, which produces the wrong output in the Net_worth sheet:

=IF(AND(($B4<$Input.$C$31),($B4<$Input.$G$31)),$Expenses.$D4,(-1)*$N4)

It should be this:

=IF(AND(($B4<$Input.$C$31),($B4<$Input.$G$31)),$Expenses.$D4,$Expenses.$D4-$N4)

I'm making a net $12,000 a month after expenses for the theoretical case I am running, but your current formula is running me into the ground pretty quickly. Needs to be fixed.

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