Forum Discussion
formula
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
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)
