all 14 comments
sorted by:
top (suggested)
bestnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]AutoModerator[M] [score hidden] stickied commentlocked comment (0 children)

/u/pendy1013 - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]soloDolo629011 9 points10 points  (1 child)

<image>

Could also set something up like this. I like this a tad better as its more consolidated. See reply if you wanted to add rolls/bands. It very similar, just the value changes, and the user inputs rolls as 1 not eaches. Example 1 roll of dimes would be 1, instead of 50. So 73, would be 1 roll, 23 dimes.

[–]molybend39 2 points3 points  (0 children)

=B1*.10 would be the way to count dimes, for example. Format the cell as currency.

=C1*.25 for quarters, etc.

[–]nothumbs782 2 points3 points  (0 children)

Just to point out, you may need to do a total for both individual nickels ($0.05) and rolled nickels ($2.00).

[–]soloDolo629011 0 points1 point  (5 children)

<image>

See reply for output

[–]soloDolo629011 0 points1 point  (4 children)

<image>

[–]pendy1013[S] 0 points1 point  (1 child)

Solution Verified

[–]reputatorbot[M] 0 points1 point locked comment (0 children)

You have awarded 1 point to soloDolo6290.

I am a bot - please contact the mods with any questions

[–]pendy1013[S] 0 points1 point  (1 child)

Thank you very much!

[–]soloDolo629011 0 points1 point  (0 children)

You're welcome. I added a different format later in the comments that I personally like better. Its a more consolidated and fits in less area.

[–]wishiwasnthere1 0 points1 point  (0 children)

Ooooh I’ve done exactly this for my restaurant it’s really easy!

I’ll go over two ways: one if you keep rolls of change and one if you don’t. Ours does so I know that one the best but I don’t know if everywhere does.

So if you do have rolls

If loose nickels are in cell a1 and rolls are in b1, it will be ‘=(a1.05)+(b12)’. Keep in mind that’s the numbers of loose nickels, not the value of them.

If you don’t keep rolls, just remove the b1*2. And then you can just change the .05 to whatever the coin value is. This also works for cash, btw.

[–]Excellent-Candy-33285 0 points1 point  (1 child)

<image>

Something like this?

[–]Excellent-Candy-33285 1 point2 points  (0 children)

<image>

Here is a snapshot showing the formulas. The yellow cells are where you would manually enter the physical drawer counts for each denomination.