问题描述:
excel表格公式解释
=IF($K9="",0,SQRT((VLOOKUP(RIGHT($K9,LEN($K9)-SEARCH(",",$K9)),交点坐标!$E$3:$G$1002,2,FALSE)-VLOOKUP((LEFT($K9,SEARCH(",",$K9)-1)),交点坐标!$E$3:$G$1002,2,FALSE))^2+(VLOOKUP(RIGHT($K9,LEN($K9)-SEARCH(",",$K9)),交点坐标!$E$3:$G$1002,3,FALSE)-VLOOKUP((LEFT($K9,SEARCH(",",$K9)-1)),交点坐标!$E$3:$G$1002,3,FALSE))^2)+L9/1000)
有知道麻烦说下,恩,知道多少说多少也行
=IF($K9="",0,SQRT((VLOOKUP(RIGHT($K9,LEN($K9)-SEARCH(",",$K9)),交点坐标!$E$3:$G$1002,2,FALSE)-VLOOKUP((LEFT($K9,SEARCH(",",$K9)-1)),交点坐标!$E$3:$G$1002,2,FALSE))^2+(VLOOKUP(RIGHT($K9,LEN($K9)-SEARCH(",",$K9)),交点坐标!$E$3:$G$1002,3,FALSE)-VLOOKUP((LEFT($K9,SEARCH(",",$K9)-1)),交点坐标!$E$3:$G$1002,3,FALSE))^2)+L9/1000)
有知道麻烦说下,恩,知道多少说多少也行
问题解答:
我来补答展开全文阅读