Range in Excel

[dhir]

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

 

[Pete_UK]

This will get you the range:

=B1-A1

assuming the values are in A and B. Copy down for other values and
ranges.

Regarding your second question, when you concatenate values (either
with & or with the CONCATENATE function), you are really creating text
values, so if you want a numeric result you may need to use SUM or
VALUE. Post back with further details if this does not resolve the
issue for you.

Hope this helps.

Pete