Question

Locked

cvil engineering survey stationing in excel 2007

By jww2 ·
I want to know how to enter a survey station such as 1+06.42 & 4+ 98.35 and get the differnce as a number = 3**.93 Excel keeps giving me an error message "value"

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Not sure what you mean by survey - but if what you want is

by Deadly Ernest In reply to cvil engineering survey s ...

to add A to B then subtract it from B added to C with all four figures entered in different columns that's simple. All you need do is read any book on excel, or their help files.

Create five columns with the data entered in the first four in order, then this formula in the fifth; assuming the columns are A,B,C,D and are on row I:

=sum((C1+D1)-(A1+B1))

Some versions of excel will need it expressed as

=sum(C1+D1)-(A1+B1)

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums