At 622 characters, our formula looks esoteric, but gradually becomes simple once you begin to understand the logical technique I used to manipulate the arrays. In this article, we will dissect the parts of such formula in the solution file. The Circumstances of the Challenge

You might have encountered some formula solutions for FIFO Inventory but none rendered only a single formula. In this article, we will dissect the parts of each of our two formulas in the solution file. The Circumstances of the Challenge

Did you ever search for examples of Excel array manipulation techniques? You might have found some but none of which applies to financial reporting. In this article, we will delve into the techniques I exploited to solve my eight profit formula challenges, which I earlier posted at Microsoft Excel Tech…

Interpretation of the Standard The crux of the questions above is the plausible interpretation of Paragraphs 6 and 7 of International Accounting Standard 7 [Statement of Cash Flows], which provide that: 6. Cash equivalents are short‑term, highly liquid investments that are readily convertible to known amounts of cash and which are subject to an…

Inspired by the reply of John Alsdorf, I modified my Excel NumToWords Formula to consider Dollars as a currency built into it. I’ll explain the modification I did to my formula here. Parts of NumToDollars Formula My NumToDollars formula is a defined name that comprises twenty-two (22) other defined names, of which the first…

Search for Similar Formulas My Google search for an Excel formula to convert number to words returned these results: User Defined Functions, such as Number2Words, NumberAsText, NumberToWords, NumsToWords, NumToWords, NUMWORD, spellCurrency, SPELLDOLLAR, SpellNumber, and SpellNumberEDP. Esoteric Built-in Formulas, such as those created by Jamil Mohammad, ndthanh, Peter Menhennet, and The FrankensTeam.