Hi Jamal,

You will get better results if you make all of the changes I have suggested. Even so, I think you have the wrong error values. In your worksheet, you display them as negative values:
but the total error is really '00º00'25''', a positive value, since your included angle is too great. This amount, in total, has to be deducted from the other angles. A negative error would have to be added. You can get the correct result by changing C12 from:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9),"[hh]ºmm'ss''")
to:
=IF(C11<C9,"","-")&TEXT(ABS(C9-C11),"[hh]ºmm'ss''")
and changing C13 from:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9)/C10,"[hh]ºmm'ss''")
to:
=IF(C11<C9,"","-")&TEXT(ABS(C9-C11)/C10,"[hh]ºmm'ss''")
You will now get the correct values in column D also (00º00'05'').

Then, if you use the following formula in column E:
=C3-(C$9-C$11)/C$10
you will get the correct result for that column.

The formula in column I, for working with the corrected angles, should therefore be:
=MOD(I3+E4+7.5,15)

Similarly, the formulae in columns O & P, for calculation the distance corrections, should be:
=(H4/G$9)*M$10
and:
=(H4/G$9)*M11
and the formulae in columns Q & R, for calculating the correct distances, should be:
=M4-O4
and:
=N4-P4

See attached worksheet.

Attached Files

Angles.xlsx (14.9 KB, 57 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]