# Helping with formula which calculate payment term

1. ## Helping with formula which calculate payment term

Hi Guys,

Example: I have 3 years contract worth £3000 first payment will be paid in first year however the rest on the end of the contract. The problem with that is first payment will be paid like that: 93% of 75% what does mean by that is the supplier will agreed with us they will pay us 75% of the 100% but because of the risk the will pay 93% of our 75% the rest will be paid on the end of our contract which is our 25% + 7%.
I can calculate it manually but it is time consuming if I have 50 contracts a day. I need one formula which calculate for me everything right now

2. ## Re: Helping with formula which calculate payment term

Hi, maybe in E1:
=D3*75%*93%
and in J1:
=D1-E1

3. ## Re: Helping with formula which calculate payment term

Hi,

Thanks for that, yes this is easy formula which I am currently using, I was thinking something more advanced such as one formula to each column, in your example I have to each year calculate separately I wish to create one formula which calculate me everything in one time.

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

#### 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