formula

Copper Contributor

i need a formula to be able to divide a number into multiple numbers for instance: if i had a piece of wood with the length of 4800mm that number could be dived into 1000, 1000,1000,1000,800 or 3000, 1800. i need a formula to be able to calculate this with any number inputted

1 Reply

Hi Shyann,

 

If your input is pair of numbers (4800, 1000) or (4800,3000), etc. and the output is text string when the formula could be

=REPT(TEXT(B1,"0") & ", ",INT(A1/B1)) & " " & MOD(A1,B1)

Divider.JPG