Question Locked

cvil engineering survey stationing in excel 2007

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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 = 391.93 Excel keeps giving me an error message "value"

2 replies

by deadly ernest

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)

This discussion is closed to new replies.