•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting dimes, nickels, quarters
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]
Want to read more?
Check out the full article on the original site
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