Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Help with formula

    Ok people this may be very easy but I have limited experience and have to get this working asap. I will explain the best i can..
    looks like this

    amount owed 1rst pymnt pymnt date 2nd pymnt 2nd date Balance
    j-5 k-5 L-5 m-5 n-5 o-5

    ==Ok if j-5 greater than $50 then devide to k-5 and m-5
    ==if j-5 less than $50 then do not devide and let k-5 be total owed.

    ok balance = j-5 less k-5 if anything in L-5 and if anything in n-5 then balance = j-5 - k-5 - m-5 = 0-5.

    Does this make since? I tried to make it easy as I can. please help asap...

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Welcome to the board. A couple of questions for you. Are these cell references? i.e. J5, K5, L5,...?

    amount owed 1rst pymnt pymnt date 2nd pymnt 2nd date Balance
    j-5 k-5 L-5 m-5 n-5 o-5

    ==Ok if j-5 greater than $50 then devide to k-5 and m-5
    ==if j-5 less than $50 then do not devide and let k-5 be total owed.
    What do you mean by "divide" to K5 and M5? Does each get a percent of the total in J5?

    Seems as if you are mixing references. In the first line, you indicate that K5 is "1rst pyment" then in the next section you say "let K5 be total owed" - can't be both.

    ok balance = j-5 less k-5 if anything in L-5 and if anything in n-5 then balance = j-5 - k-5 - m-5 = 0-5.
    Is "balance" supposed to be J5 - K5 - M5 = O5

    Might be easier if you attached a worksheet and put in what you expect to have happen.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Yes they are referances. What i am wanting to do is put in a invoice number and amount. Then if the total is over 50 dollars then have the amount owed devided in to 2 payments and show the 1rst and 2nd payment. then i will put the dtae in when I payroll deduct thatpayment and the balance I want to reflect the balance as each payment is made. I am mor ethan open to any and all suggestions,... I can change the sheet anyway I need to ..

    the misc. field is to pay for bonuses and etc.
    thanks again

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Okay, now, suppose that J5 is 80. Do you want K5 to be 50, and M5 to be 30? Or do you want them to be divided equally? K5 = 40 and M5 = 40?

    Also, the way you have described this, your balance will always be 0. Is that what you want? In other words, this setup will tell you how much the payment is to be, not what is actually paid.

    Sounds like maybe you will need two extra columns: one for first actual payment, and the other second actual payment. Then your balance would be:

    Balance = Amount owed - 1st Actual - 2nd Actual
    Last edited by shades; 12-01-03 at 13:55.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Okay, I assumed you wanted two equal payments.

    And I added the two columns. If this is not what you want, post back.
    Attached Files Attached Files
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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