Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Major bug on Rollup sheet column O #1

Open
HPCguy opened this issue Nov 13, 2023 · 0 comments
Open

Major bug on Rollup sheet column O #1

HPCguy opened this issue Nov 13, 2023 · 0 comments

Comments

@HPCguy
Copy link

HPCguy commented Nov 13, 2023

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.

@HPCguy HPCguy changed the title Major bug on rollup sheet column O Major bug on Rollup sheet column O Nov 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant