1 min readfrom 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

submitted by /u/pendy1013
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article