calculating number of bars to use but also stating the remainder

Hi Guys sorry about the naming of this
but i rele havnt got a clue what this is that im asking for
anyone know if there is any where that i can get help on the naming of threads???


i need some simple formula for this

bar lengths are 5600
i have Quantitys and a cell with the total
length

i need to be able
to put in the length to be cut off
and then the ammount that i want.

so say i have 5 bars
with a total of 28000

and i need 7 lengths of 2000
i need to have a formula to see
how many full bars are needed
and what i will have left

so i will have 1600 x 3
and 3600 x 1

using 4 bars

any ideas
this could also be done in a form

Anyone got anything? or even trying?
i am trying and failing here

lookin good thanks mark