Hi all,
In my excel I have a column:
A: 'Capex' or 'Opex'
B: The name of the item (f.e. 'car')
E: Price (dollar)
F: Cylus
G: accounting depreciation (%)
H: date of transaction/start
In column J I've made a constraint but it is nog complete yet. Can anybody help me?
Its allmost okay, but with 'OPEX' it calculates ((the difference between date column H and 31-12-2019)*1), instead of the actual spent costs (which is different when column F has another value than '1').
It is quite a puzzle!!!
Regards,
Martin
Bookmarks