1. Registered User
Join Date
Dec 2003
Posts
2

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.

2. Registered User
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.

3. Registered User
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. Registered User
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.

5. Registered User
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.

#### Posting Permissions

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