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? |
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) |