I'm trying to calculate the distance between two known Stations (i.e. 100+00
and 200+00) for an easy measure of plan quantities. The Difference between
these two points is 100+00, and the sum is 300+00; obviously (or 100 and 300
respectfully). Ok, so how is this done in Excel to arrive with an answer in
either working number format?
The formatting is a custom type: 000+00, but the cell still references #VALUE.

1. First, you need to convert the engineering station format (i.e. 100+00) into a decimal format. To do this, you can use the formula
   Formula:

   =LEFT(A1,FIND("+",A1)-1)+RIGHT(A1,2)/100 

   , where A1 is the cell containing the engineering station. This formula will give you the decimal equivalent of the engineering station.
2. Once you have converted both engineering stations into decimal format, you can simply subtract the smaller value from the larger value to get the distance between the two stations. For example, if your two stations are in cell A1 and A2, you can use the formula
   Formula:

   =ABS(A2-A1) 

   to get the distance between them.
3. To format the result in the engineering station format, you can use the custom number format "000+00". To apply this format, select the cell with the result, right-click and select "Format Cells", then choose "Custom" and enter "000+00" in the Type field.

If you are still getting a #VALUE error after applying the custom number format, it could be because the cell is not recognizing the value as a number. In this case, you can try converting the value to a number by using the formula , where A1 is the cell with the result. This should convert the value to a number that can be formatted using the custom number format.

What is 300+00 supposed to be? Is this 300 x 10^0 (=300)? If so, Excel calls
this scientific notation, and uses the format:
300E0

Either enter your numbers as lay people do, or enter it in Excel's
scientific notation. Then do your calculations normally (ie =a1+b1)

Regards,
Fred.

"Jupraven" wrote in message
...
I'm trying to calculate the distance between two known Stations (i.e.
100+00
and 200+00) for an easy measure of plan quantities. The Difference
between
these two points is 100+00, and the sum is 300+00; obviously (or 100 and
300
respectfully). Ok, so how is this done in Excel to arrive with an answer
in
either working number format?
The formatting is a custom type: 000+00, but the cell still references
#VALUE.

firstly, try checking the number format in the given cells, it may have been
typed as text. if so, changed the number format into 0+00 and type 10000 &
20000 for 100+00 & 200+00, respectively.

since the answer will be in one cell (e.g C1), you can format it as general
E.G.
A1=100+00 <number format as 0+00 meaning 100*100 = 10000 in feet
B1=200+00 <number format as 0+00 meaning 200*100 = 20000 in feet
C1=B1-A1 <number format as general for plan measures as quantity
presentation
meaning 20000-10000= 10000

regards,


"Jupraven" wrote:

I'm trying to calculate the distance between two known Stations (i.e. 100+00
and 200+00) for an easy measure of plan quantities. The Difference between
these two points is 100+00, and the sum is 300+00; obviously (or 100 and 300
respectfully). Ok, so how is this done in Excel to arrive with an answer in
either working number format?
The formatting is a custom type: 000+00, but the cell still references #VALUE.

If you are using a custom number format 000+00, and the numbers are entered
as numbers, the calculation will work and display correctly.

If, however, you type the number in as 100+00, instead of as 10000, it will
be interpreted as text, and hence your #VALUE! error.

If some or all of your "numbers" are text, you could use something like
=LEFT(A1,3)+LEFT(A2,3)&"+"&RIGHT(A1,2)+RIGHT(A2,2) , which of course gives
the answer as text.
=(LEFT(A1,3)+LEFT(A2,3))*100+RIGHT(A1,2)+RIGHT(A2, 2) would give a number
which could be formatted 000+00.
--
David Biddulph

"Jupraven" wrote in message
...
I'm trying to calculate the distance between two known Stations (i.e.
100+00
and 200+00) for an easy measure of plan quantities. The Difference
between
these two points is 100+00, and the sum is 300+00; obviously (or 100 and
300
respectfully). Ok, so how is this done in Excel to arrive with an answer
in
either working number format?
The formatting is a custom type: 000+00, but the cell still references
#VALUE.