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,...
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)