On Jul 1, 11:02 pm, Brad Best
wrote:
"Spiky" wrote:
On Jun 30, 5:00 pm, Brad Best
wrote:
not sure how relevant his is however but c3 is a weekly total that references
the previous weeks total and the current weeks totals as well and of course
is the cell I want to =0, the effected cell needs to be b1 as any shortage
for the week in outgoing bills need to come from the savings entry,
transversely all excess funds need to go into b1 hence b1 needs to adjust
itself to ensure that c1 remains =0

Well, it's certainly relevant. But I'm not sure it is enough. Where is
the previous week total? Where is the current week total? What is the
actual formula in C3?

If I'm understanding, you want to have B1 equal the inverse of all the
other cells being added in C3, that will always make C3=0. So I guess
you have to look at the formula in C3 and reverse it in B1, more or
less. The only issue is to make sure you don't cause a circular
reference.

the circular reference is a problem and again why im asking for help

so C3 actually references another weeks + incoming - outgoing and is
specific to each week. now b1 at current is a simple input cell which can be
relocated to accommodate a formula as im sure that will need to happen
anyway. im not even sure if im helping at this point or making things more
complicated.

Well, you aren't exactly giving any more info. So I'd say you're
neither helping nor making it more complicated.

Sounds like you want C3 to be: PriorBalance + Incoming - Outgoing +
AdjustCell

So you need that AdjustCell to have this formula: Outgoing - Incoming
- PriorBalance