Results 1 to 3 of 3

basic formula help needed

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    basic formula help needed

    Hi guys I would be grateful if someone could advise me on the correct formula to use for the following task.

    Please see the attached spreadsheet (excel 2007)

    Column "K" is the cumulative profit for reference "KH". I want this column to total up all the totals in column J.

    The cumulative profit (column K) is a sum of money that is owed to a partner in a joint business venture. I need column's L and M to reflect what money had been paid and what money is owed - is that possible?

    For example, you can see that the cumulative profit for KH so far is 764.18. If I were to enter "500" in column L, I would want column M to show that 264.18 is still owed......

    Hope that makes some kind of sense.....

    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1