Hello all - newbie question: I am making an index of chapters in a series of books, and I have one cel for the first page and the next cel for the last page.
Example - Chapter One begins on page 1, ends on page 5.
I’d like to make the third cel count the numbers inclusive. Answer of course should be 5.
I’ve tried subtracting 5-1 but of course that doesn’t work, as there are 5 pages in the chapter.
I’ve made a little workaround formula (cel 2-cel1)+1
but is there a better way of doing this?
I am looking to eventually bring the table into a calc database.
Thank you for your consideration,