Solved: Split payment formula in Excel needed

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Lostinexcel2002

Thread Starter
Joined
Aug 26, 2007
Messages
11
I would like to know if it is possible to have a formula to do the following:

A3=2000 claim for damage on a vehicle
B3=1000 lien balance................

need an equation to display split payments for the following below:

C3=1000 payable to lien holder
D3=1000 payable to vehicle owner for remaining equity

I would also like to include the following formula to the equation above:

A3=1000 claim damage on vehicle
B3=2000 lien balance..................

Equation is as follows:

C3=1000 owed to the lien
D3=0 No equity owed to the owner as they are upside down


Hope I have made it clear........

Thanks in advance
 

cwwozniak

Chuck
Moderator
Joined
Nov 28, 2005
Messages
68,741
Yes, it is possible if I understand your requirements correctly.

Will the attached sheet do what you want? I did a few rows with different amounts to test the formulas. I also added a comment column. The sheet has locked cells except for the claim and lien balance entries and is protected without any password
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top