Did I insinuate that government grants are taken for granted? Literally, I didn’t. But figuratively, I did. Let me explain.

In this period of the COVID-19 pandemic, businesses gratefully embrace government grants like life buoys to keep them afloat. But when and how do businesses initially recognize the government grants…

Age of Receivables
What is, and how do we calculate, the age of receivables?

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

How do costs flow under the FIFO formula?

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

Rubik’s Cube Puzzles
Excel Arrays are manipulated like Rubik’s Cube Puzzles

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.

Microsoft Excel Built-in Formula to convert Number to Dollars
Excel NumToDollars Formula

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:

  1. User Defined Functions, such as Number2Words, NumberAsText, NumberToWords, NumsToWords, NumToWords, NUMWORD, spellCurrency, SPELLDOLLAR, SpellNumber, and SpellNumberEDP.
  2. Esoteric Built-in Formulas, such as those created by Jamil Mohammad, ndthanh, Peter Menhennet, and The FrankensTeam.

Inspired by the…

Robert Hontoria Gascon

Certified Public Accountant ✔ Tax Consultant ✔ Trusted Contributor of Microsoft Excel Tech Community ✔ Author of EXCELlent Financial Accounting and Reporting

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store