Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) |