LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Conditional formatting based on text within a formula Sarah Jane Excel Worksheet Functions 13 October 12th 06 04:12 PM
Calculating only non-empty cells... Jay Excel Worksheet Functions 9 September 22nd 06 03:20 AM
Conditional Formatting Against a Formula - not it's result Mike The Newb Excel Discussion (Misc queries) 3 August 10th 06 10:33 PM
Conditional formatting...cont. from 9/25 Guenzak Excel Discussion (Misc queries) 4 September 26th 05 10:55 PM


All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"