•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting dimes, nickels, quarters
Our take
Setting up a cash count sheet can streamline your restaurant’s financial management and make counting coins and bills more efficient. To achieve this, you can create a simple formula that automatically calculates the dollar value based on the number of coins or bills entered. For example, inputting the quantity of dimes will convert it into dollars by multiplying the amount by 0.10.
Hey! Very inexperienced spreadsheeter here, and I have to set up a cash count sheet for the restaurant that I work at. I’m wondering how to set it up so that you put the amount of coins/bills in a cell and it automatically calculates the $ value of the amount to get added into the total. I know how to make a cell add up other cells, just not sure how to make each cell turn 73 dimes into $7.30, or 35 5 dollar bills into $175 for the totals
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#Excel alternatives#cash count sheet#coins#bills#calculate#total#spreadsheeter#value#dimes#nickels#quarters#cell#amount#add up#restaurant