Newbie question about intervals and results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey, I'm having these (hopefully simple problems) with writing in page numbers:

1. I want to write ex. "7-19" in a cell -
Then in another cell I want excel to give the "result" of the interval of,
here 12.

2. Now, if that's possible, I also want to ask this:
In one cell i want to write 2 or more different interval, ex
"7-19, 81-90".

Can I make excel understand what I'm writing somehow? And get the result of
these intervals in another cell, here 21 (12+9)

Any help will be extremely appreciated - thanks in advance, steve.
 
If you had 7 in one cell, minus in another cell and 19 in a third cell then
an IF statement could do the formula.
 
your first question is easily done thusly:

=RIGHT(A1,LEN(A1)-FIND("-",A1))-MID(A1,1,FIND("-",A1)-1)

Where A1 contains "7-19" the result will be 12 (say in cell B2)

You can repeat this sequence on multiple cells (in column A)and the
sum the cells with the results in column B.

I would not try your second option. Rather, place each component i
adjoining columns and create formulas to analyze each.

HT
 
Back
Top