How can I link two cells with a conditional formula?
 

I've read several posts and have now found the answer, I hope someone can
help me.

My situation is this... I am working on a 'cash flow' analysis that, at one
point, takes positive cash flow and applies it to a loan payment.... Put
simply, when ever the cash flow is positive it would automatically be added
to a payment amount. But I want this to be conditional and only applied when
the cash flow reaches certain amounts, so if cash flow is negative the amount
is 'ignored'.

Here's what I have:
Cell 1, total cash flow: =SUM(K117-K119-K121-K123+K125)+J131
Cell 2, payment amount: =(J117-J121)

So basically anytime Cell 1 is over a certain amount it would add that
amount to the total result in cell 2, but if cell 1 is below a set amount
it's ignored.

ideas?

How can I link two cells with a conditional formula?
 

You can try something like this in Cell2:

If(C1="specify amount here",C1+(J117-J121),J117-J121)



"phooey" wrote:

I've read several posts and have now found the answer, I hope someone can
help me.

My situation is this... I am working on a 'cash flow' analysis that, at one
point, takes positive cash flow and applies it to a loan payment.... Put
simply, when ever the cash flow is positive it would automatically be added
to a payment amount. But I want this to be conditional and only applied when
the cash flow reaches certain amounts, so if cash flow is negative the amount
is 'ignored'.

Here's what I have:
Cell 1, total cash flow: =SUM(K117-K119-K121-K123+K125)+J131
Cell 2, payment amount: =(J117-J121)

So basically anytime Cell 1 is over a certain amount it would add that
amount to the total result in cell 2, but if cell 1 is below a set amount
it's ignored.

ideas?

How can I link two cells with a conditional formula?
 

Ed,

Thanks for your help. That particular formula didn't work but it did get me
on the right track.

Here's what I used:
=SUM(IF(F117-F119-F121-F123+F125+E131=1,F117-F121+F131,F117-F121))
So if the formula is =1 it adds the cell, if not it doesn't.

Now.. all I have to do is figure out how to get that to work for fields that
have not accumulated data yet I'll be all set :-)

"Ed" wrote:

You can try something like this in Cell2:

If(C1="specify amount here",C1+(J117-J121),J117-J121)



"phooey" wrote:

I've read several posts and have now found the answer, I hope someone can
help me.

My situation is this... I am working on a 'cash flow' analysis that, at one
point, takes positive cash flow and applies it to a loan payment.... Put
simply, when ever the cash flow is positive it would automatically be added
to a payment amount. But I want this to be conditional and only applied when
the cash flow reaches certain amounts, so if cash flow is negative the amount
is 'ignored'.

Here's what I have:
Cell 1, total cash flow: =SUM(K117-K119-K121-K123+K125)+J131
Cell 2, payment amount: =(J117-J121)

So basically anytime Cell 1 is over a certain amount it would add that
amount to the total result in cell 2, but if cell 1 is below a set amount
it's ignored.

ideas?