Forum Discussion
Converting number range (0-10) to range value (10)
Hello all, I'm trying to convert a column of number ranges (formatted 0-10, 10-25) into the value of the range (10-25 = 15 etc.) Can anybody help me with a function to do this? Additionally an...
owenmyers27 Perhaps best demonstrated in a working example. See attached. I kept the "helper cells" in it, so that you can see the steps needed to come to the end result. Hope you think it's helpful.