Formula that calculates the difference between numbers

Hi Hi,

I'm trying to create a formula that would be able to calculate the difference between the numbers and writes it exactly as shown in this image:

https://postimg.cc/RWGhy3Q8
https://docs.google.com/spreadsheets...dgQ/edit#gid=0

I have been trying to solve this problem for several days, thanks for any help

I sew home-made large stuffed animals and I need it to evenly sew some parts.

thanks :-)

Unsure of your ask. Are your attempting to get the difference between 25 and 3? If not then please explain in more detail what you are attempting.

If I am understanding your pictures correctly, you want a formula (must it be a single cell formula?) that will:
1) Start with the first number. (=B3)
2) Calculate the difference between the successive pairs of numbers (=C3-B3 copied across).
3) Join the results of step 1 and 2 in a hyphen delimited text string? =TEXTJOIN("-",FALSE,range containing values)

Did I understand correctly?

If you aren't required to do it all in a single cell:

1) In B6 =B4-A4. Copy/paste/fill into C6:K6
2) In L6 =TEXTJOIN("-",TRUE,B6:K6).
3) Copy B6 and paste into B11, B16, etc.

I don't understand. How does this hyphen delimited text string fit into the downstream calculations? In what way does the downstream calculation know that the text string was generated over several cells, and how does that impact the downstream calculation? What is the nature of the downstream calculation?

Provide a link to the Google Sheet, not umages.

OK - I have amended your opening post to make that more obvious. I've also moved the thread to the correct forum section.

Thank you very much, really very much, and I'm sorry for not writing earlier.
I was in the hospital, I had an accident that was not my fault.


Your funstions works perfectly, that's exactly what I needed

Another option:

Please try in B5 and copy to the other cells:

Formula:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.