Hello,
I'm having trouble with an issue. I have some columns projecting savings contributions over time (from column N to AA), and my problem is with the "TFSA" section, namely the "Unused contribution room" in column Q. (For context, TFSAs are a Canadian savings account type that have limited contribution room, so I want to be able to add to it without exceeding that limit.) The limit is off to the right somewhere.
This column (Q) is fed by direct contributions to this section, as well as outgoing moneys from the other sections (non-registered savings, and join non-registered savings).
I could easily make an IF statement in Q (the Unused Contribution Room ) telling it not to decrease itself if it would be below zero, however that would not balance well with the rest of the sheet, because the other sections that feed it (the non registered savings areas) would still display transfers going out.
I need a way for the columns that feed Q (non registered savings) to stop doing so when it would make Q drop below zero, but without directly referencing Q, because that would create a circular reference.
All columns that transfer into or feed the Q column are first aggregated into column R. Those columns are T and U, and U is an aggregate of X, AA and AC).
In the sample file (just cut out a snippet of my program), you'll notice I've referenced the cell above the corresponding cell in Q in order to avoid circular references, however this creates ugly looking jumps and gaps, and not what I want. The columns feeding Q should STOP outputting / stop populating with negative values when Q becomes negative.
Edit: As in the legend, the blue areas are input and the reddish are output. The blue boxes in row 5 are what populate most of the columns here. You can type Y to contribute the max, or a custom number.
Any help is greatly appreciated!
I'm having trouble with an issue. I have some columns projecting savings contributions over time (from column N to AA), and my problem is with the "TFSA" section, namely the "Unused contribution room" in column Q. (For context, TFSAs are a Canadian savings account type that have limited contribution room, so I want to be able to add to it without exceeding that limit.) The limit is off to the right somewhere.
This column (Q) is fed by direct contributions to this section, as well as outgoing moneys from the other sections (non-registered savings, and join non-registered savings).
I could easily make an IF statement in Q (the Unused Contribution Room ) telling it not to decrease itself if it would be below zero, however that would not balance well with the rest of the sheet, because the other sections that feed it (the non registered savings areas) would still display transfers going out.
I need a way for the columns that feed Q (non registered savings) to stop doing so when it would make Q drop below zero, but without directly referencing Q, because that would create a circular reference.
All columns that transfer into or feed the Q column are first aggregated into column R. Those columns are T and U, and U is an aggregate of X, AA and AC).
In the sample file (just cut out a snippet of my program), you'll notice I've referenced the cell above the corresponding cell in Q in order to avoid circular references, however this creates ugly looking jumps and gaps, and not what I want. The columns feeding Q should STOP outputting / stop populating with negative values when Q becomes negative.
Edit: As in the legend, the blue areas are input and the reddish are output. The blue boxes in row 5 are what populate most of the columns here. You can type Y to contribute the max, or a custom number.
Any help is greatly appreciated!
Attachments
Last edited: