Suggestion and the recommendation of special functions depreciation
Excel includes 5 formulas to calculate depreciation (SLN,DB,DDB,VDB,SYD) and all of these formulas do not include cells for Starting Date and end date for the cycle to calculate depreciation using it except for VDB formula. For example if we want to calculate depreciation for a specific asset starting from 1st of july,2010 to 31st of December,2015. Using the current existing Excel formulas, depreciation can not be calculated directly. However it is used to calculate depreciation for the whole calendar year starting 1st January till 31st of December not for a partial period starting or ending in different dates. As An example of how complex to calculate depreciation using Excel formulas is SLN method.---------------------------------------------------------------------------------- =IF($A7=1,SLN($A$1,$A$2,$A$3)*((DATEDIF($A$4,DATE(YEAR($A$4),MONTH($A$5),DAY($A$5)),"M")+1)/12), IF($A7=$A$3+1, ((12-((DATEDIF($A$4,DATE(YEAR($A$4),MONTH($A$5),DAY($A$5)),"M")+1)))/12)*SLN($A$1,$A$2,$A$3),SLN($A$1,$A$2,$A$3))) so I hope and recommend that every supervisor in the Arabic blog to help and support to add two more cells to depreciation formulas *Starting date *End date These recommendation make depreciation formulas more useful and matching the accounting the standards whereas depreciation expense is a major expense and miscalculating it leads to disaster. Best regardsINDEX MATCH the easy way
I've created a short video on how to use a trick to create INDEX MATCH formula quicker. Also, my suggestion for a revised version of INDEX MATCH is now at number 6 (as at 22nd Sep 2016) in the most voted for improvements to Excel. https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/14049132-make-a-simple-safer-version-of-vlookup-and-index-m
how to run personal macro workbook creating folder
hi every one, Can give anyone best suggestion to me to run personal macro workbook but the first-time I'm trying to run that, when it try to run personal macro workbook one message is showing "personal macro workbook in the startup folder must stay open for recording, unable to record" can any give best steps to run macro and how to creat a folder i dont know regards vikasdevFind the smallest value other than zero
Sometimes my question is the search for the smallest value, except for zero The function min or small But fail to it because it will come in short, a smallest value of zero And we are forced to do the work of an array formula, such as in the picture And the following suggestion Argument optional functions max min av small large To neglected zero. It will be a very, very useful Greetings to you
Formula or function for IF statement based on cell color
I don't know how to code in VBA but am trying to automate an if/then calculation based on cell color. As shown in the picture, if the colors of the cells in column B are the same as those in Column G across the row, I want to subtract the values in columns F and K in the same row to return the absolute value of the subtraction in column L. If the colors of the cells are different, I want to add the values in columns F and K and return the value in column L. I will have multiple tables of varying numbers of rows where I need to perform this operation. Any help is greatly appreciated.3 ways to drive business decisions using the new Excel 2016 charts
With the release of Office 2016, we unveiled a set of highly anticipated new charts to give you more ways to explore data and tell rich stories across Excel, Word and PowerPoint. The Waterfall, Histogram, Box & Whisker, Pareto, Treemap and Sunburst are six examples of powerful new charts that help you quickly visualize common financial, statistical and hierarchical data. Get the full story at https://blogs.office.com/2016/02/04/3-ways-to-drive-business-decisions-using-the-new-excel-2016-charts/Número por extenso, sem VB ou macro
Olá! Criei uma planilha simples, Pará escrever número por extenso. Uma planilha não tem função, fazer UO de macro VB. Uma solução é aparentemente simples, especialmente porque, em português, há poucas variações. O arquivo está livre para edição. Sucesso nós todos de pará!
