formula

Highlighted
shyann weekes
Occasional Visitor

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

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies