设等级结果在B2,结果在C2,请在C2输入公式:=LOOKUP(B2,{"不合格","合格","良好","优秀","中等";"55","65","85","95","75"}) 等级在公式中要升序排列。
设等级结果在B2,结果在C2,请在C2输入公式:=LOOKUP(B2,{"不合格","合格","良好","优秀","中等";"55","65","85","95","75"}) 等级在公式中要升序排列。
Copyright © 2018 - 2021 www.yd166.com., All Rights Reserved.