Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Newbie question about intervals and results
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. |
#2
|
|||
|
|||
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. "Steve" wrote: 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. |
#3
|
|||
|
|||
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 then sum the cells with the results in column B. I would not try your second option. Rather, place each component in adjoining columns and create formulas to analyze each. HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=465395 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |