Sep 04 2017
08:54 AM
- last edited on
Jul 25 2018
10:01 AM
by
TechCommunityAP
Sep 04 2017
08:54 AM
- last edited on
Jul 25 2018
10:01 AM
by
TechCommunityAP
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
Sep 04 2017 09:46 AM
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)