Capturing Formulas in Excel
Unfortunately, it is easy to delete a formula. Of course, there is always Undo but if the file has been closed getting the formula back is difficult unless…..
(more…)
Unfortunately, it is easy to delete a formula. Of course, there is always Undo but if the file has been closed getting the formula back is difficult unless…..
(more…)
Excel has Paste List option to list the range names in the file. Here’s a macro that does it in one click.
(more…)When working with financial years and depreciation you often have the situation where the asset being purchased has been purchased during the year and not at the start of the year. Here's a function that calculates fixed declining balance depreciation and handles part year depreciation. The DB function has an optional fifth argument that allows you to specify how many months did appreciate in the first year. In the image below you can see the DB function being used in…