Hi all,
Apologies if this has been answered else where but I can't seem to find anything.
I have a spreadsheet monitoring spend of a project there are a few different elements but I have simplified what I need for this purpose.
Each project has a with hold amount that we will pay up to until certain criterias are satisfied and I need a formula to calculate payments up to this threshold but a period claim could take them over the threshold but will require part payment up to the threshold (sorry if I am not being clear).
Please see the attached work sheet.
The formula is obviously doing what I have told it to as in period 8 the sum becomes greater than the with hold threshold so it is returning a £0.00, but what do I need to amend in this to show £6,000 in the period 8 to be paid cell in oder to take the actual amount to be paid to the withold threshold?
Many thanks in advance for your help and I apologise if I am not making sense I have been staring at this for hours now and just don't know what I need to do.
Sasha
Bookmarks