aged

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

Hello, I created this code to apply this formula to the first row and then copy it down until the end, but then it does not work if the data/table only has one row. My code is below if anyone can help that would be great, I think it may just be something I am forgetting. thanks! 'Days Aged...

Hello. I'm having some trouble with this formula. Can someone please help? example: cell B5 says -6% formula ="aged debtors decreased by "&B5 ideally i would like the result to be "aged debtors decreased by -6%" but is coming up with "aged debtors decreased by -0.56988713816163" any help...

Hi I am trying to get an aged creditor report to update the ageing when i update the current month. I.e currently May will be month 1, but next month it will be 0 and remain as such (June will become 1, July 2 etc) The file goes forward 5 years so i need it to be specific to month and year. An...