I am running a sheet for invoicing. We are held retention on contracts and I want to be able to lookup the final retention so that I can reference the total retention held. This will not be the total, but the final value. For example “Contract 1” – Should return a value of £0.00 as the retention is no longer Held, where “Contract 2” £75.00 as only 2.5% retention.
The calculations in the fields will be done manually, however with upto 80 contracts running and upto 50 applications this formula would be most useful.
|Value Works||Retention Held||Net Value|