Xử lý lỗi hàm công thức (1 người xem)

[nhjngj]

Chào các bác.
Em có 1 file Excel này để phục vụ công việc vì là file em download trên mạng nên bị lỗi ở Cột J, bắt đầu từ dòng 8. để nhập các góc ngoặt trên/ dưới.
(File này là 1 dạng lisp để chạy trên autocad.)
Công thức như này:
=IF(IF(DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0))))>=0,DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)))),180-ABS(DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0))))))>IF(DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0))))>=0,DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0)))),180-ABS(DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0)))))),"gt.dwg",IF(IF(DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0))))>=0,DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)))),180-ABS(DEGREES(ATAN((VLOOKUP($B9,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B9,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0))))))=IF(DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0))))>=0,DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0)))),180-ABS(DEGREES(ATAN((VLOOKUP($B8,Elevation!$A$1:$D$6105,4,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,4,0))/(VLOOKUP($B8,Elevation!$A$1:$D$6105,3,0)-VLOOKUP($B7,Elevation!$A$1:$D$6105,3,0)))))),"180-t.dwg","gd.dwg"))
Khi em save as file sang 1 file khác thì bị lỗi: =#VALUE!
Em upfile lên đây nhờ bác nào rành về cái này thì chỉnh sửa giúp em với ạ.
Em xin cảm ơn!
File CL-TD-14-Cap là file gốc
File Test là file sau khi Save as bị lỗi #Value.