Please help asap.

fliggyg

New Member
Joined
Dec 1, 2003
Messages
1
First thank you in advance for your help
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

The fields were suppose to be under the titles. ex: amount owed =j-5 1rst pymnet = k-5 and so on.
==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...
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Try in K5:

=IF(J5<=50,J5,ROUND(J5/2,2))

in M5:

=J5-K5

in O5:

=(L5<>"")*K5+(N5<>"")*M5

assuming you delete the payment dates when the amount is paid.
 
Upvote 0
A quick addendum:

(a) Welcome to the board!
(b) A posting tip: when referring to cell addresses, just put J5, K5, L5, etc. It's actually a bit confusing if you insert a dash into your cell reference since in "traditional" Excel parlance "J-5" would be read as "Column J minus five".

(Edit) Just saw Andrew's post. His suggestion of using the Round() function to avoid problems with decimals and then using subtraction in M5 is indeed probably a better way to go. (End Edit)
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top