Dear Members,
1.I am right now working in some data in which I have negative and
positive value.
What I am trying to do with that data is that finding the range in
that data let see the example

-15 to 20 = Range is 35(or I can say rise by 35)
-15 to -20 = Range is -5(or I can say fall by 5)
+15 to 20 = Range is +5(or I can say rise by 5)
+15 to -20 = Range is -35(or I can say fall by 35)

I want the final result +35, -35 +5, -5.


2. I Concatenate some values from some cells into one cell and put
some formula to pick the numeric value from that cell but it did not
give me the right final result. When I change the value manually on
the concatenated cell then the final result get change rightly but not
by own. What is the reason?


Thank in advance....
Thanks You
dhir