利用附合导线坐标计算和道路中桩坐标计算2个实例，对高速公路测量计算中涉及的部分Excel函数进行列举分析，按照各个实例的计算步骤和程序设计好工作表的结构并将工作表截图附在文中，详细给出主要单元格中所利用的函数和公式。着重分析如何利用IF嵌套函数减少人工判断，通过详细的计算步骤和程序的分析具体展示如何合理布置工作表结构。

Taking the calculation of the coordinates of the connecting traverses and the calculation of the coordinates of highway centerline stakes as examples, the author analyses some related functions of Excel in highway survey calculations. According to the actual calculation process of each case and the worksheet structures designed by the program, the author presents the functions and equations used in the main cells with screen capture of the worksheets. Moreover, the author mainly analyses how to use IF nested function to reduce the manual judgment and how to rationally dispose the worksheet structures by means of detailed calculation process and program analysis.