以紫之隧道路面设计高程计算、衬砌类型长度统计为例,阐述Excel软件中IF函数、SUMIF函数在紫之隧道工程设计中的运用。结果表明,工程设计中灵活使用Excel函数可提高工作效率。 Taking the calculation of design elevation of tunnel of purple tunnel and the length of lining type as an example, the application of IF function and SUMIF function in Excel software in the design of tunnel of purple tunnel is expounded. The results show that flexible use of Excel functions in engineering design can improve work efficiency.