excel电子表格中字母怎样转化为数字?答:用LOOKUP()或TEXT()。例如:=lookup(a2,{"A","B","C","D","E","F","G"},{1,2,3,4,5,6,7})
EXCEL中如何把字母变成数字答:=IF(Sheet1!A1="A",6,(IF(Sheet1!A1="B+",5,(IF(Sheet1!A1="B",4,(IF(Sheet1!A1="B-",3,(IF(Sheet1!A1="C+",2,(IF(Sheet1!A1="C",1,0)))公式如上,用IF嵌套函数。在SHEET1中的A1输入A,在SHEET2中的A1位置输入如上公式,即可得6,输入B+,则自动跳5,类推。