[請問] excel找概數已回收
A B
1 6.623 29.32
2 6.372 28.76
3 6.122 28.20
4 5.875 27.65
5 5.629 27.12
資料表如上，如果我算出來的數據A行是6.110(每次都不一樣，但會在6.623~5.629之間)
想根據資料表找出對應的B行的數據(概數即可)大概是多少
請問公式應該要怎麼寫，謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.230.132.193
※ 文章網址: http://www.ptt.cc/bbs/ask/M.1412733338.A.7F4.html
推
10/08 09:58, , 1F
10/08 09:58, 1F
→
10/08 09:58, , 2F
10/08 09:58, 2F
→
10/08 09:59, , 3F
10/08 09:59, 3F
→
10/08 10:00, , 4F
10/08 10:00, 4F
→
10/08 10:00, , 5F
10/08 10:00, 5F
→
10/08 10:01, , 6F
10/08 10:01, 6F
→
10/08 10:01, , 7F
10/08 10:01, 7F
→
10/08 10:01, , 8F
10/08 10:01, 8F
→
10/08 10:02, , 9F
10/08 10:02, 9F
→
10/08 10:07, , 10F
10/08 10:07, 10F
→
10/08 10:14, , 11F
10/08 10:14, 11F
推
10/08 10:17, , 12F
10/08 10:17, 12F
→
10/08 10:20, , 13F
10/08 10:20, 13F
推
10/08 10:22, , 14F
10/08 10:22, 14F
→
10/08 10:29, , 15F
10/08 10:29, 15F