电子表格中将abc等级转换为分数的方法是：设等级结果在B2，结果在C2，请在C2输入公式：=LOOKUP(B2,{"不合格","合格","良好","优秀","中等";"55","65","85","95","75"}) 等级在公式中要升序排列。