Excel Formulas To use Cash denomination calculator in Excel!!

With the INT function in combination with functions like SUMPRODUCT , we can do the cash denomination calculator to perform different calculations. This tutorial will walk through the steps to dynamically reference a set of data in other functions. Let’s see the simple formula used for the cash denomination calculator ** in Excel. Get an official version of ** MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• Use the below-mentioned formula to use cash denomination calculator.

=[INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)((amount-[SUMPRODUCT](https://geekexcel.com/how-to-use-sumproduct-function-with-criteria-in-excel/)(denoms,counts))/currentdenom)

Syntax Explanation

• INT – The INT function will round a given integer number down to the nearest integer.
• SUMPRODUCT ** – This function helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the **SUMPRODUCT Function.
• **Parenthesis () – **The main purpose of this symbol is to group the elements.
• Comma symbol (,) – It is a separator which helps to separate a list of values.
• Minus Operator (-) – This symbol will help to subtract any two values.
• Division (/) – It is used for dividing values or numbers.

Practical Examples

• Firstly, you have to create a sample data in Excel.

Sample data

• Then, to calculate required currency denominations, you need to use the following formula in formula bar.

=[INT](https://geekexcel.com/how-to-use-excel-int-function-in-office-365-with-examples/)(($B5-[SUMPRODUCT](https://geekexcel.com/how-to-use-sumproduct-function-with-criteria-in-excel/)($C$4:C$4,$C5:C5))/D$4)

Use the Formula

• Now, you have to Hit the Enter key to get the result as shown below in the cell C5.

Result for the cell C5

• Finally, you need to press Ctrl+D key to get the results in all other columns.

Final Output

Closing Words

Here, we have described the simple formulas for the cash denomination calculator in Excel. I hope this article helps you. Feel free to ask back any questions and let us know how it goes. I will keep working with you until it’s resolved.

Thank you so much for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!

Related Articles:

• How to use Loan Calculator through Excel Office VBA?
• How to use the XNPV function in Excel office 365?
• Fetch Values From Cells for Calculation in Excel Office 365!!
• Excel Formulas to Get the Percent Change ~ Quick Method!!
• Excel Formulas to Check Date is Same Month ~ A Complete Tutorial!!