Choose your language

Count dollar bills

Intermediate Exercise


Statement

Create a Function that receives an integer as input and returns as few dollar bills as possible (100, 50, 20, 10, 5, 2, and 1) to compose it. The result should be expressed in 7 separate cells in the worksheet (one for each bill).


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Once the function is done, you can select the seven cells into which the Function will be inserted, place the function in the first one and press Ctrl + Shift + Enter to replicate to the others.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape