Trying to count boxes in inventory

[Jerry Garcia]

Ladies and Gentlemen,
I'm trying to count how many boxes I have left in inventory after using .22 long rifle ammo. I don't know how to step up a formula in cell J3, for example. Every box of 22 long rifle contains 50 rounds. What I am trying to do is every time I use a certain amount of rounds, I want to place the amount used in cell I3 until there has been the equivalent of one box used and the number of boxes will appear in J3 with respect to cell C3.

[xladept]

I put these formulas in J3,K3 and L3

Please Login or Register  to view this content.

Is that what you want?

[Jerry Garcia]

Thanks!!! That's what I was looking for.

[xladept]

You're welcome and thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[way2020]

Ammo Used Boxes Used Boxes Left
Enter amt used =I3/50 =H3-J3

Copy the formula down in column J3 then copy the formula down in K3

I attached a file with these changes

Don't forget to say "Thank You" to those who have helped you in your thread. If
you wish, you can also reward them by clicking on their reputation star bottom
left.

If this resolves your problem then click on Thread Tools at the top and mark it
solved.