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 and even more helpful would be a function that can convert this number range column which is in cm (0-10) to a number range in inches (0-10 cm 0-3.937 in). If somebody can help me do one of these things it would save me buckets of time.
Best regards,
Owen
1 Reply
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.
