[算表] 請問參照儲存格內容存取特定儲存格資料內容的函數
軟體:M$ Office Excel 2002
例如參照的儲存格是 A1
當 A1 = 0 的時候 B1=A2
A1 = 1 B1=A3
A1 = 2 B1=A4
.
.
A1 = 9 B1=A11
類似這樣的功能要用哪個函數
--
▄ ▄
▄ ▄ http://gaaan.com/Doraemon
▃ ▃ http://www.hemidemi.com/group/Doraemon/home
≡ ˙ ≡ http://www.anobii.com/groups/01a4164bdf5309b73f/
▄▄ ▽ ▄▄
▄▂⊕▂▄ http://geniuskiki.blogspot.com/
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.132.28.51
推
09/26 06:35, , 1F
09/26 06:35, 1F
推
09/26 11:50, , 2F
09/26 11:50, 2F