我用圖表呈現
四個點為一個座標格
A006.5K-7KA00.30280.33040.31150.33930.31260.33240.30410.324
A106K-6.5KA10.31150.33930.32050.34810.3210.34080.31260.3324
A206.5K-7KA20.30410.3240.31260.33240.31360.32560.30550.3177
A306K-6.5KA30.31260.33240.3210.34080.32160.33340.31360.3256
A406.5K-7KA40.30550.31770.31360.32560.31460.31870.30680.3113
A506K-6.5KA50.31360.32560.32160.33340.32210.32610.31460.3187
B006K-5.6KB00.32070.34620.32920.35390.32930.34610.32120.3389
B105.3K-5.6KB10.32920.35390.33760.36160.33730.35340.32930.3461
B205.6K-6KB20.32120.33890.32930.34610.32930.33840.32170.3316
B305.3K-5.6KB30.32930.34610.33730.35340.33690.34510.32930.3384
B405.6K-6KB40.32170.33160.32930.33840.32940.33060.32220.3243
B505.3K-5.6KB50.32930.33840.33690.34510.33660.33690.32940.3306
C005K-5.3KC00.33760.36160.34630.36870.34560.36010.33730.3534
C104.7K-5KC10.34630.36870.35520.3760.35390.36690.34560.3601
C205K-5.3KC20.33730.35340.34560.36010.34480.35140.33690.3451
例如 輸入一個點座標為 0.34356 0.35907 (如圖表紅點顯示位置為C00)
請問我要如何用EXCEL 以函數計算方式 求出這紅點 在座標格範圍內 顯示C00
謝謝
