[算表] 如何設定:輸入英文,出現指定的數值
軟體:Excel
版本:2002 (10.6871.6870) SP3
要 Key in 學生成績
因為考卷上的評分有寫A B C D 四種
換算公式大家已講好: A是90分, B是80分, C是70分, D是60分
請問在excel的儲存格中要如何設定
可以讓我在前一格輸入A,然後游標跳下一格時,前一格出現90 ?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.113.160.80
※ 編輯: hatsuki 來自: 140.113.160.80 (03/15 16:47)
推
03/15 16:51, , 1F
03/15 16:51, 1F
→
03/15 16:51, , 2F
03/15 16:51, 2F
→
03/15 16:52, , 3F
03/15 16:52, 3F
→
03/15 16:52, , 4F
03/15 16:52, 4F
→
03/15 16:55, , 5F
03/15 16:55, 5F
→
03/15 16:56, , 6F
03/15 16:56, 6F
→
03/15 16:56, , 7F
03/15 16:56, 7F
→
03/15 16:58, , 8F
03/15 16:58, 8F
→
03/15 16:58, , 9F
03/15 16:58, 9F
→
03/15 16:59, , 10F
03/15 16:59, 10F
→
03/15 17:00, , 11F
03/15 17:00, 11F
→
03/15 17:00, , 12F
03/15 17:00, 12F
推
03/15 21:24, , 13F
03/15 21:24, 13F
→
03/16 00:22, , 14F
03/16 00:22, 14F
→
03/16 12:37, , 15F
03/16 12:37, 15F