#### Superjakeny

##### New Member

- Joined
- Aug 31, 2014

- Messages
- 4

There are several pieces -8marks 6 marks 4 marks 2 marks 1 mark and a half mark. I want to put in a number in the field and let excel figure out how many of each piece I need to fulfill the order.

You always use as many 8marks as you can example.

I have an order of 100 how many marks do i need. I would need 12 mark 8's and 1 mark 4. how do I get excel to do this for me

eample

order is 87 I need 10 mark 8's 1 mark 6 and 1 mark 1. How do I get excel to do this?

Thanks for the help everyone!