Hi All,
I have costs in ageing bucket and a provision in 1 column. I wish to deduct provision from cost ageing based on LIFO method and arrive at a net aged cost.
There are few checks to be applied:-
1. Total provision to be deducted can not exceed total aged cost.
2. Provision has to be deducted in aged manner. Based on available amount.
I have attached an excel file for 3 different examples for better understanding. I wish to arrive at provision subtraction from cost ageing based on a formula so that it can be checked. I have over 10k line items hence need a formula. Dont need VBA as it cant be explained to auditor.
I have costs in ageing bucket and a provision in 1 column. I wish to deduct provision from cost ageing based on LIFO method and arrive at a net aged cost.
There are few checks to be applied:-
1. Total provision to be deducted can not exceed total aged cost.
2. Provision has to be deducted in aged manner. Based on available amount.
I have attached an excel file for 3 different examples for better understanding. I wish to arrive at provision subtraction from cost ageing based on a formula so that it can be checked. I have over 10k line items hence need a formula. Dont need VBA as it cant be explained to auditor.
